On Tue, Jul 20, 2010 at 3:30 AM, John Kane <jrkrid...@yahoo.ca> wrote: > Assuming your data is in data.frame xx > > ============================================================ > library(reshape) > mm1 <- melt(xx, id=c("ID")) > cast(mm1, ID ~ variable ) > =============================================================
That code just goes in a circle! the result of cast(mm1, ID ~ variable) is equal to xx. Here is one way to do it with the melt/cast functions from the reshape package: m.dat <- melt(dat, id = "ID") m.dat <- cbind(m.dat, colsplit(m.dat$variable, split = "_", names = c("begin.end","t"))) m.dat$variable <- NULL dat.final <- cast(m.dat, ... ~ begin.end) Hope it helps, Ista > > --- On Mon, 7/19/10, Thomas Jensen <thomas.jen...@eup.gess.ethz.ch> wrote: > >> From: Thomas Jensen <thomas.jen...@eup.gess.ethz.ch> >> Subject: [R] Reshaping data >> To: R-help@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@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. >> > > > > ______________________________________________ > R-help@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. > -- Ista Zahn Graduate student University of Rochester Department of Clinical and Social Psychology http://yourpsyche.org ______________________________________________ R-help@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.