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