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]]
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.
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 info at aghmed.fsnet.co.uk http://www.aghmed.fsnet.co.uk/home.html