[R] Reshaping data
John Kane
jrkrideau at yahoo.ca
Tue Jul 20 05:30:00 CEST 2010
Assuming your data is in data.frame xx
============================================================
library(reshape)
mm1 <- melt(xx, id=c("ID"))
cast(mm1, ID ~ variable )
=============================================================
--- On Mon, 7/19/10, Thomas Jensen <thomas.jensen at eup.gess.ethz.ch> wrote:
> From: Thomas Jensen <thomas.jensen at eup.gess.ethz.ch>
> Subject: [R] Reshaping data
> To: R-help at r-project.org
> Received: Monday, July 19, 2010, 6:48 PM
> Dear All,
>
> I have some data in the following shape:
>
> ID
> begin_t1 end_t1
> begin_t2 end_t2
> Thomas
> 11/03/04 13/05/06
> 04/02/07 16/05/08
> ...
> ...
> ...
> ...
> ...
> Jens
> 24/01/02 23/05/03
> 07/06/03 14/11/05
>
> I would like to reshape this data to have the following
> form:
>
> ID
> Begin_Time End_Time
> Thomas
> 11/03/04 13/05/06
> Thomas
> 04/02/07 16/05/08
> ...
> ...
> ...
> Jens
> 24/01/02 23/05/03
> Jens
> 07/06/03 14/11/05
>
> I have been doing some google searches and looked at the
> reshape library, but so far I have not been able to shape
> the data like I want. If you guys could help, I would
> greatly appreciate it!
>
> Best, Thomas
>
> ______________________________________________
> 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