Re: [R] Break up a data frame

From: jim holtman <jholtman_at_gmail.com>
Date: Thu, 20 Mar 2008 04:45:58 -0500

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?

______________________________________________
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.
Received on Thu 20 Mar 2008 - 09:48:20 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 20 Mar 2008 - 10:30:24 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive