[R] summary table newbie question
Jeff D. Hamann
jeff.hamann at forestinformatics.com
Wed May 12 18:41:24 CEST 2004
I've got a newbie question and I got a little lost in the "table helps".
I've got a data.frame I would like to summarize as a (and pardon for the
lack of correct vernacular) data collection matrix. My data looks like,
stand siteindex age acres pct.acres
1 232 116 45 8477.3105 0.56159458
2 234 121 25 11120.1530 0.73667441
3 235 132 25 5399.4605 0.35769691
4 236 115 5 6308.3969 0.41791103
5 240 116 45 473.1533 0.03134489
6 241 116 15 21790.9595 1.44358105
7 245 171 25 686.9867 0.04551066
8 246 134 25 15176.8082 1.00541478
9 247 99 35 1754.9282 0.11625835
10 251 125 55 7396.1098 0.48996851
...blah, blah, blah...
and when I attempt to create a summary table using aggregate, I get the
following results,
> aggregate( stands$acres, by=list(stands$age,stands$siteindex), sum )
Group.1 Group.2 x
1 95 86 6403.5457
2 5 88 1517.6781
3 45 88 3555.3213
4 125 89 6269.2633
5 95 90 3154.3531
6 55 93 14006.9781
7 15 94 98.9918
8 35 94 2241.0531
9 105 94 431.0281
but what I really want is a matrix where the rows and columns are classes
(in increments of 5 or 10 or whatever) and the cells are the sums (or means
or whatever) for the data.frame. I guess it would be equivalent to like
surf.ls/surf.gls without fitting a trend but that would also allow me to
plot the results graphically in addition to simply printing out the table
using xtable.
Jeff.
---
Jeff D. Hamann
Forest Informatics, Inc.
PO Box 1421
Corvallis, Oregon USA 97339-1421
541-754-1428
jeff.hamann at forestinformatics.com
www.forestinformatics.com
More information about the R-help
mailing list