creating Pivot
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