dimitris fekas wrote on 01/18/2012 03:21:44 AM: > I have a data frame and I would like to reshape it to wide format > while at the same time applying different aggregate functions to > each column AND at times multiple aggregate functions: > > test1 = data.frame( > id = c(rep('101',8),rep('102',8)), > phase = rep(c('D','D','L','L'),4), > day = rep(c('1','1','1','1','2','2','2','2'),2), > col1 = c(rep(1,8),rep(2,8)), > col2 = c(runif(8,min=0,max=1),runif(8,min=0,max=10)) > ) > > In this example, I would like to end up with 2 rows (for the 2 ids) > and different columns for phase-day. Values of col1 > should just be summed and for col 2 there should be a column with the > mean AND one with standard deviation for each phase-day combination. > > Obviously the real data have much more number of columns therefore I > guess I will need to provide a list of functions? > > Thank you in advance!
It's not clear to me what you want to end up with. You seem to want four separate columns for each phase-day combination. But then you describe summary statistics for both col1 and col2. Can you provide an example, test2, to make it clear? Jean [[alternative HTML version deleted]] ______________________________________________ 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.