Try this:
reshape(xx, direction = "long", varying = list(2:4), idvar = "country")
On Wed, Mar 9, 2011 at 11:15 AM, 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.
>
>
--
Henrique Dallazuanna
Curitiba-Paraná-Brasil
25° 25' 40" S 49° 16' 22" O
[[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.
