Re: [R] conditional sum two dataframes

2012-07-26 Thread Rui Barradas
Hello, Try the following. m <- unlist(months) v <- unlist(values) aggregate(v ~ m, FUN=sum) tapply(v, m, sum) Hope this helps, Rui Barradas Em 26-07-2012 18:49, jcrosbie escreveu: I have two data frames. One with a matrix of months and the other with a matrix of values. The two dataframes c

Re: [R] conditional sum two dataframes

2012-07-26 Thread Bert Gunter
The values need not be a data frame as the number of unique months could be different among the columns, right?. So you're going to have to rethink your data structure. Probably as a list. Once you get that straight,?tapply and friends should make it trivial, if I understand you correctly. -- Ber

[R] conditional sum two dataframes

2012-07-26 Thread jcrosbie
I have two data frames. One with a matrix of months and the other with a matrix of values. The two dataframes correspond to each other. I would like to sum up all the values in by month. What would be an efficient way to do this? a=C(2,3,5,2,3,5) b=c(2,6,3,2,6,3) c=c(2,6,7,2,6,5) months <- dat