[R] creating Pivot
Jim Lemon
jim at bitwrit.com.au
Wed Jul 25 09:58:34 CEST 2012
On 07/25/2012 02:41 PM, namit wrote:
> Hi Friends,
>
>
> I'm new to R.I have a data frame :
>
> xxx having columns color name values
> R XXX 10
> G YYY 4
> Y ZZZ 5
> G XXX 2
> Y XXX 3
> R YYY 2
> Y YYY 1
> R ZZZ 2
> G ZZZ 3
>
>
> Now i want to have the data in this format R G Y
>
>
> XX X 10 2 3
>
> YYY 2 4 1
>
> ZZZ 2 3 5
>
> Can you please help me on this.
>
Hi Namit,
I think what you want is "reshape". Try this:
ndat<-data.frame(col=c("R","G","Y","G","Y","R","Y","R","G"),
xyz=c("XXX","YYY","ZZZ","XXX","XXX","YYY","YYY","ZZZ","ZZZ"),
val=c(10,4,5,2,3,2,1,2,3))
reshape(ndat,v.names="val",idvar="xyz",timevar="col",direction="wide")
Jim
More information about the R-help
mailing list