Re: [R] data manipulation involving aggregate

2009-05-29 Thread Gabor Grothendieck
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

[R] data manipulation involving aggregate

2009-05-29 Thread Simon Pickett
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 "habitat"s each with an associated "area". I want to aggregate t