[R] Rearranging the data

[Santosh Srinivas]

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.
>
>