Re: [R] Data manipulation with aggregate

Message - From: Filoche pmassico...@hotmail.com To: r-help@r-project.org Cc: Sent: Tuesday, July 3, 2012 12:04 PM Subject: [R] Data manipulation with aggregate Hi everyone. I have these data : myData = data.frame(Name = c('a', 'a', 'b', 'b'), length = c(1,2,3,4), type = c('x','x','y','z

[R] Data manipulation with aggregate

Hi everyone. I have these data : myData = data.frame(Name = c('a', 'a', 'b', 'b'), length = c(1,2,3,4), type = c('x','x','y','z')) which gives me: Name length type 1a 1x 2a 2x 3b 3y 4b 4 z I would group (mean) this DF using 'Name' as

Re: [R] Data manipulation with aggregate

try this: myData = data.frame(Name = c('a', 'a', 'b', 'b'), length = c(1,2,3,4), type + = c('x','x','y','z')) result - do.call(rbind, lapply(split(myData, myData$Name), function(.name){ + data.frame(Name = .name$Name[1L] + , length = mean(.name$length) + , type = if (all(.name$type[1L] ==

[R] data manipulation involving aggregate

hi all, I often have a data frame like this example data.frame(sq=c(1,1,1,2,2,3,3,3,3),area=c(1,2,3,1,2,3,1,2,3),habitat=c(garden,garden,pond,field,garden,river,garden,field,field)) for each sq I have multiple habitats each with an associated area. I want to aggregate the data frame so that

Re: [R] data manipulation involving aggregate

Try this: as.data.frame.table(xtabs(area ~ habitat + sq, DF), responseName = area.sum)[c(2:3, 1)] sq area.sum habitat 1 10 field 2 13 garden 3 13pond 4 10 river 5 21 field 6 22 garden 7 20pond 8 2