[R] transforming column of a dataframe by var- and median-functions
Agrarimmobilien
ralf.pfeiffer at agrarimmobilien.info
Sun Mar 9 21:37:30 CET 2008
Hello,
I try to transform a data frame like
A B C
1 1 2,5
2 2 NA
3 1 1,0
4 1 56
5 2 23
6 1 NA
7 2 46
to the following dataframe, calculating the variance and median of the
C-column, group by B, so the result will be:
B C(median) D (var)
1 19,83 9
2 34,5 21
Doing this, I got problems with the NAs in column C.
I tried to combine the aggregate - function
aggregate(C, list(B), FUN=(mean, var))
with the following functions
var(C, use="complete.obs")
median(C, rm.na=TRUE)
but it doesn't work as I want. Has anybody an idea how to do this work?
thank you
Iksmax
More information about the R-help
mailing list