[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