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
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
2 matches
Mail list logo