[R] creating Pivot

[Jim Lemon]

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