[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