need help to convert in to panel data format

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

need help to convert in to panel data format

Ramesh Chandra Das
Dear All,
The data format is like this
  Company  2001 2001 2001 2002 2002 2002 2003 2003 2003 2004 2004 2004  3M
India Ltd. 1160.2 2082.7 67.1 1094.3 1069.9 221.6 1160.2 2082.7 67.1 1094.3
1069.9 221.6  A B B India Ltd. 7758 7932.8 698.2 7205.4 7617.3 1272.5 7758
7932.8 698.2 7205.4 7617.3 1272.5  Aditya Birla Nuvo Ltd. 11871.4 15259.5
1571.9 10834.1 18851.3 7430.7 11871.4 15259.5 1571.9 10834.1 18851.3
7430.7  Alstom
T & D India Ltd. 4182.5 4035.3 -25.4 4279.5 3812.1 770.2 4182.5 4035.3 -25.4
4279.5 3812.1 770.2  B A S F India Ltd. 3799.9 4194.6 416.1 3420.5 3557.7
1406.3 3799.9 4194.6 416.1 3420.5 3557.7 1406.3  Balmer Lawrie & Co. Ltd.
6987.2 7445.8 4.1 7215.4 5750.5 1695.6 6987.2 7445.8 4.1 7215.4 5750.5
1695.6  Bhilai Engineering Corpn. Ltd. 1501.1 1378.1 152.3 1370.6 1227.4
175.1 1501.1 1378.1 152.3 1370.6 1227.4 175.1  Bombay Burmah Trdg. Corpn.
Ltd. 1846.9 1607.6 3.8 1947.5 2411.3 683.4 1846.9 1607.6 3.8 1947.5 2411.3
683.4  Clariant Chemicals (India) Ltd.
3346.5 3520.1 512.2 2951.3 2691.9 901.6 3346.5 3520.1 512.2 2951.3 2691.9
901.6 would some one help to convert into panel data format.
Thanks and regards
========================================================
Ramesh Chandra Das
Doctoral Student
Vinod Gupta School of Management
Indian Institute of Technology, Kharagpur,
West Bengal, India, PIN - 721 302
Phone: 91+ 9002883115

        [[alternative HTML version deleted]]

______________________________________________
[hidden email] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Reply | Threaded
Open this post in threaded view
|

Re: need help to convert in to panel data format

Bert Gunter
1. Do not post in HTML -- it gets filtered out or scrambled (although
we could probably figure it out anyway if we were so inclined. I am
not.). See ?dput to see how to copy and paste in a text format that we
can use to easily reconstruct your data structure.

2. You will probably have to more clearly define what you mean by
"panel format." I certainly have no clue.

3. Have you read relevant portions on manipulating data frames, etc.
of an Introduction to R
(http://cran.r-project.org/doc/manuals/R-intro.pdf ) or other online
tutorial? If not, please do your homework and do so before posting
further.

Cheers,
Bert

Bert Gunter
Genentech Nonclinical Biostatistics
(650) 467-7374

"Data is not information. Information is not knowledge. And knowledge
is certainly not wisdom."
H. Gilbert Welch




On Sun, Feb 16, 2014 at 9:49 AM, Ramesh Chandra Das
<[hidden email]> wrote:

> Dear All,
> The data format is like this
>   Company  2001 2001 2001 2002 2002 2002 2003 2003 2003 2004 2004 2004  3M
> India Ltd. 1160.2 2082.7 67.1 1094.3 1069.9 221.6 1160.2 2082.7 67.1 1094.3
> 1069.9 221.6  A B B India Ltd. 7758 7932.8 698.2 7205.4 7617.3 1272.5 7758
> 7932.8 698.2 7205.4 7617.3 1272.5  Aditya Birla Nuvo Ltd. 11871.4 15259.5
> 1571.9 10834.1 18851.3 7430.7 11871.4 15259.5 1571.9 10834.1 18851.3
> 7430.7  Alstom
> T & D India Ltd. 4182.5 4035.3 -25.4 4279.5 3812.1 770.2 4182.5 4035.3 -25.4
> 4279.5 3812.1 770.2  B A S F India Ltd. 3799.9 4194.6 416.1 3420.5 3557.7
> 1406.3 3799.9 4194.6 416.1 3420.5 3557.7 1406.3  Balmer Lawrie & Co. Ltd.
> 6987.2 7445.8 4.1 7215.4 5750.5 1695.6 6987.2 7445.8 4.1 7215.4 5750.5
> 1695.6  Bhilai Engineering Corpn. Ltd. 1501.1 1378.1 152.3 1370.6 1227.4
> 175.1 1501.1 1378.1 152.3 1370.6 1227.4 175.1  Bombay Burmah Trdg. Corpn.
> Ltd. 1846.9 1607.6 3.8 1947.5 2411.3 683.4 1846.9 1607.6 3.8 1947.5 2411.3
> 683.4  Clariant Chemicals (India) Ltd.
> 3346.5 3520.1 512.2 2951.3 2691.9 901.6 3346.5 3520.1 512.2 2951.3 2691.9
> 901.6 would some one help to convert into panel data format.
> Thanks and regards
> ========================================================
> Ramesh Chandra Das
> Doctoral Student
> Vinod Gupta School of Management
> Indian Institute of Technology, Kharagpur,
> West Bengal, India, PIN - 721 302
> Phone: 91+ 9002883115
>
>         [[alternative HTML version deleted]]
>
> ______________________________________________
> [hidden email] mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.

______________________________________________
[hidden email] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Reply | Threaded
Open this post in threaded view
|

Re: need help to convert in to panel data format

Michael Dewey
In reply to this post by Ramesh Chandra Das
At 17:49 16/02/2014, Ramesh Chandra Das wrote:

>Dear All,
>The data format is like this
>   Company  2001 2001 2001 2002 2002 2002 2003 2003 2003 2004 2004 2004  3M
>India Ltd. 1160.2 2082.7 67.1 1094.3 1069.9 221.6 1160.2 2082.7 67.1 1094.3
>1069.9 221.6  A B B India Ltd. 7758 7932.8 698.2 7205.4 7617.3 1272.5 7758
>7932.8 698.2 7205.4 7617.3 1272.5  Aditya Birla Nuvo Ltd. 11871.4 15259.5
>1571.9 10834.1 18851.3 7430.7 11871.4 15259.5 1571.9 10834.1 18851.3
>7430.7  Alstom
>T & D India Ltd. 4182.5 4035.3 -25.4 4279.5 3812.1 770.2 4182.5 4035.3 -25.4
>4279.5 3812.1 770.2  B A S F India Ltd. 3799.9 4194.6 416.1 3420.5 3557.7
>1406.3 3799.9 4194.6 416.1 3420.5 3557.7 1406.3  Balmer Lawrie & Co. Ltd.
>6987.2 7445.8 4.1 7215.4 5750.5 1695.6 6987.2 7445.8 4.1 7215.4 5750.5
>1695.6  Bhilai Engineering Corpn. Ltd. 1501.1 1378.1 152.3 1370.6 1227.4
>175.1 1501.1 1378.1 152.3 1370.6 1227.4 175.1  Bombay Burmah Trdg. Corpn.
>Ltd. 1846.9 1607.6 3.8 1947.5 2411.3 683.4 1846.9 1607.6 3.8 1947.5 2411.3
>683.4  Clariant Chemicals (India) Ltd.
>3346.5 3520.1 512.2 2951.3 2691.9 901.6 3346.5 3520.1 512.2 2951.3 2691.9
>901.6 would some one help to convert into panel data format.

I think you need reshape
?reshape should get you started.

>Thanks and regards
>========================================================
>Ramesh Chandra Das
>Doctoral Student
>Vinod Gupta School of Management
>Indian Institute of Technology, Kharagpur,
>West Bengal, India, PIN - 721 302
>Phone: 91+ 9002883115
>
>         [[alternative HTML version deleted]]

Michael Dewey
[hidden email]
http://www.aghmed.fsnet.co.uk/home.html

______________________________________________
[hidden email] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.