[R] need help to convert in to panel data format

Bert Gunter gunter.berton at gene.com
Sun Feb 16 19:02:16 CET 2014


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
<rameshchandradas99 at gmail.com> 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]]
>
> ______________________________________________
> R-help at r-project.org 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.




More information about the R-help mailing list