Skip to content

creating Pivot

4 messages · namit, Jim Lemon, Rui Barradas +1 more

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


Thanks, 
Namit 





--
View this message in context: http://r.789695.n4.nabble.com/creating-Pivot-tp4637711.html
Sent from the R help mailing list archive at Nabble.com.
Jim Lemon
#
On 07/25/2012 02:41 PM, namit wrote:
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
Rui Barradas
# 
Hello,

Try the following.

dat <- read.table(text="
  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
", header=TRUE)
d

xtabs(values ~ name + color, data=dat)

Hope this helps,

Rui Barradas
Em 25-07-2012 05:41, namit escreveu:
John Kane
# 
# note file name is xx.

library(reshape2)

 dcast(xx, name ~ color, value.var = "values")

John Kane
Kingston ON Canada
____________________________________________________________
FREE 3D EARTH SCREENSAVER - Watch the Earth right on your desktop!