[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