Re: [R] Rearranging the data

From: Santosh Srinivas <santosh.srinivas_at_gmail.com>
Date: Wed, 09 Mar 2011 19:50:06 +0530

reshape2 Like this?

> require(reshape2)

Loading required package: reshape2
> melt(xx)

Using country as id variables
  country variable value

1     USA        x    10
2      UK        x    50
3  Canada        x    20
4     USA        y    40
5      UK        y    80
6  Canada        y    35
7     USA        z    70
8      UK        z    62
9  Canada        z    10

>

On Wed, Mar 9, 2011 at 7:45 PM, Vincy Pyne <vincy_pyne_at_yahoo.ca> wrote:
> Dear R helpers,
>
> xx = data.frame(country = c("USA", "UK", "Canada"), x = c(10, 50, 20), y = c(40, 80, 35), z = c(70, 62, 10))
>
>> xx
>        country      x     y    z
> 1      USA        10    40  70
> 2
>  UK          50   80   62
> 3     Canada    20   35   10
>
>
>
>
> I need to arrange this as a new data.frame as follows -
>
> country       type     values
> USA            x         10
> USA            y         40
> USA            z         70
> UK             x         50
>
> UK             y         80
> UK             z         62
> Canada         x         20
> Canada         y         35
> Canada         z         10
>
> I did try reshape package but things are in mess. Please guide
>
> Regards
>
> Vincy
>
>
>
>        [[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.
>
>



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 Wed 09 Mar 2011 - 14:22:32 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 Wed 09 Mar 2011 - 14:40:20 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