Dear All,
Can someone help me on how to reshape the data that I have attached please.
Isaiah
Reshaping Data
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
Reshaping Data
- Attachments
-
- EVIEWS FORUM.xls
- Reshaping Data
- (770.5 KiB) Downloaded 284 times
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13306
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Reshaping Data
That's a very generic question. You're going to have to give a lot more detail before anyone can answer sensibly.
Follow us on Twitter @IHSEViews
Re: Reshaping Data
Dear Gareth
Sorry that the question was not specific. I would like to reshape the data to be a panel data format. For example:
Bank Country Year Var1 Var2 Var2
HSBC UK 2015 0.2 0.17 0.16
HSBC UK 2014 0.7 0.21 0.19
BARCLAYS US 2015 0.8 0.34 0.41
BARCLAYS US 2014 0.71 0.24 0.51
Hope this will help.
Thanking you in anticipation.
Isaiah
Sorry that the question was not specific. I would like to reshape the data to be a panel data format. For example:
Bank Country Year Var1 Var2 Var2
HSBC UK 2015 0.2 0.17 0.16
HSBC UK 2014 0.7 0.21 0.19
BARCLAYS US 2015 0.8 0.34 0.41
BARCLAYS US 2014 0.71 0.24 0.51
Hope this will help.
Thanking you in anticipation.
Isaiah
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13306
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Reshaping Data
Dear Gareth
I had attached the data on my previous email. Nevertheless, it is attached herein. I would like to reshape the data to be a panel data format. For example:
Bank Country Year Var1 Var2 Var2
HSBC UK 2015 0.2 0.17 0.16
HSBC UK 2014 0.7 0.21 0.19
BARCLAYS US 2015 0.8 0.34 0.41
BARCLAYS US 2014 0.71 0.24 0.51
Thanking you in anticipation.
Isaiah
I had attached the data on my previous email. Nevertheless, it is attached herein. I would like to reshape the data to be a panel data format. For example:
Bank Country Year Var1 Var2 Var2
HSBC UK 2015 0.2 0.17 0.16
HSBC UK 2014 0.7 0.21 0.19
BARCLAYS US 2015 0.8 0.34 0.41
BARCLAYS US 2014 0.71 0.24 0.51
Thanking you in anticipation.
Isaiah
- Attachments
-
- EVIEWS FORUM.xlsx
- (1.1 MiB) Downloaded 264 times
-
- Non-normality and collinearity are NOT problems!
- Posts: 3775
- Joined: Wed Sep 17, 2008 2:25 pm
Re: Reshaping Data
When I drag-and-dropped the file onto EViews 9, it came up as a bank by year panel. What is it different that you want?
Re: Reshaping Data
Dear Startz
I am using Eviews 6 and it does not come as a panel.
isaiah
I am using Eviews 6 and it does not come as a panel.
isaiah
-
- Non-normality and collinearity are NOT problems!
- Posts: 3775
- Joined: Wed Sep 17, 2008 2:25 pm
Re: Reshaping Data
An EViews 6 question is probably going to need the EViews staff for an answer.
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13306
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Reshaping Data
Could you post the workfile that occurs when you open the file in Excel?
Follow us on Twitter @IHSEViews
Re: Reshaping Data
Dear Gareth,
I have attached an excel file that I trying to import to Eviews. I have also tried Eviews 8 students version.
Regards,
Isaiah
I have attached an excel file that I trying to import to Eviews. I have also tried Eviews 8 students version.
Regards,
Isaiah
- Attachments
-
- EVIEWS FORUM.xls
- (770.5 KiB) Downloaded 258 times
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13306
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Reshaping Data
Yes, but we want the EViews file, not the Excel file.
Follow us on Twitter @IHSEViews
Re: Reshaping Data
Dear Gareth,
I have attached a short version of data as Eviews 8 would not let safe the entire data file.
I have attached a short version of data as Eviews 8 would not let safe the entire data file.
- Attachments
-
- Eviews Forum Short version data.WF1
- (34.51 KiB) Downloaded 241 times
Who is online
Users browsing this forum: No registered users and 22 guests