[R] Transposing by a group variable

John Kane jrkrideau at yahoo.ca
Thu Feb 14 20:09:38 CET 2008


How do we know what value corresponds to what new
variable?  

library(reshape)
mm <- melt(d, id="group")
cast(mm, group~value)

will give you something but not quite what you want.

--- Shubha Vishwanath Karanth
<shubhak at ambaresearch.com> wrote:

> Hi R,
> 
>  
> 
> Can I transpose a data frame by a particular group
> variable?
> 
>  
> 
> For example:
> 
> d=data.frame(group=c(1,1,2,2,2),val=c(6,4,6,3,5))
> 
> And my output should be:
> 
>
data.frame(group=c(1,2),v1=c(6,6),v2=c(4,3),v3=c(NA,5))
> 
>  
> 
> Many thanks,
> 
> Shubha
> 
> This e-mail may contain confidential and/or
> privileged i...{{dropped:13}}
> 
> ______________________________________________
> 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