[R] Calculating mean together with split

2006-09-20 Thread Rainer M Krug
Hi I have a table called npl containing results of simulations. It contains about 19000 entries and the structure looks like this: NoPlants sim run year DensPlants 16 lng_cs99_renosterbos 140.00192 . . . it has 43 different entries for sim and year goes

Re: [R] Calculating mean together with split

2006-09-20 Thread David Barron
Have a look at the function aggregate.table in the package gtools (part of the gregmisc bundle). On 20/09/06, Rainer M Krug [EMAIL PROTECTED] wrote: Hi I have a table called npl containing results of simulations. It contains about 19000 entries and the structure looks like this: NoPlants

Re: [R] Calculating mean together with split

2006-09-20 Thread David Barron
Sorry, that should have been package gdata, not gtools...they're both in the same bundle, though. On 20/09/06, Rainer M Krug [EMAIL PROTECTED] wrote: Hi I have a table called npl containing results of simulations. It contains about 19000 entries and the structure looks like this:

Re: [R] Calculating mean together with split

2006-09-20 Thread David Barron
Of course, aggregate will work too, depends on how you want the output to be formatted. You could also look at summarize in the Hmisc package. On 20/09/06, David Barron [EMAIL PROTECTED] wrote: Sorry, that should have been package gdata, not gtools...they're both in the same bundle, though.

Re: [R] Calculating mean together with split

2006-09-20 Thread Rainer M Krug
Hi David aggregate is what I was looking for, as I wanted to have it in the tabular format to plot it. Thanks Rainer David Barron wrote: Of course, aggregate will work too, depends on how you want the output to be formatted. You could also look at summarize in the Hmisc package. On

Re: [R] Calculating mean together with split

2006-09-20 Thread hadley wickham
It contains about 19000 entries and the structure looks like this: NoPlants sim run year DensPlants 16 lng_cs99_renosterbos 140.00192 . . . it has 43 different entries for sim and year goes from 1 to 100, and run from 1 to 5. I would like to

Re: [R] Calculating mean together with split

2006-09-20 Thread hadley wickham
# Then try one of these: cast(dfm, year ~ sim) cast(dfm, year + sim ~ . ) cast(dfm, year ~ sim, margins=TRUE) Oops that should be: dfm - rename(df, c(DensPlants = value)) cast(dfm, year ~ sim, mean) cast(dfm, year + sim ~ . , mean) cast(dfm, year ~ sim, mean, margins=TRUE) (Thanks for