Break up a data frame
Is this close to what you want?
x <- read.table('clipboard')
x
V1 V2 V3 V4 1 xyz 01/03/2007 15.25 USD 2 xyz 01/04/2007 15.32 USD 3 xyz 01/02/2008 23.22 USD 4 abc 01/03/2007 45.20 EUR 5 abc 01/04/2007 45.00 EUR 6 abc 01/02/2008 68.33 EUR
x.m <- melt(x)
Using V1, V2, V4 as id variables
x
V1 V2 V3 V4 1 xyz 01/03/2007 15.25 USD 2 xyz 01/04/2007 15.32 USD 3 xyz 01/02/2008 23.22 USD 4 abc 01/03/2007 45.20 EUR 5 abc 01/04/2007 45.00 EUR 6 abc 01/02/2008 68.33 EUR
cast(x.m, V2~V4)
V2 EUR USD 1 01/02/2008 68.33 23.22 2 01/03/2007 45.20 15.25 3 01/04/2007 45.00 15.32
On Thu, Mar 20, 2008 at 1:22 AM, Ravi S. Shankar <ravis at ambaresearch.com> wrote:
Hi R users,
I have a dataframe in the below format
xyz 01/03/2007 15.25 USD
xyz 01/04/2007 15.32 USD
xyz 01/02/2008 23.22 USD
abc 01/03/2007 45.2 EUR
abc 01/04/2007 45.00 EUR
abc 01/02/2008 68.33 EUR
I want to change the above data into the below format
xyz 01/03/2007 15.25 USD abc
01/03/2007 45.2 EUR
xyz 01/04/2007 15.32 USD abc
01/04/2007 45.00 EUR
xyz 01/02/2008 23.22 USD abc
01/02/2008 68.33 EUR
Any help would be welcome
Thank you
Ravi
This e-mail may contain confidential and/or privileged i...{{dropped:13}}
______________________________________________ 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.
Jim Holtman Cincinnati, OH +1 513 646 9390 What is the problem you are trying to solve?