[R] creating Pivot

Rui Barradas ruipbarradas at sapo.pt
Wed Jul 25 10:25:04 CEST 2012


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:
> 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.
>
> ______________________________________________
> R-help at 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.



More information about the R-help mailing list