[R] Adding columns of Aggregates to existing dataframe

tonyxv tonyxv at gmail.com
Sat Jun 21 03:04:30 CEST 2008


Hello,
I have a dataframe 


ID1   ID2
A1    B3
A1    B4
A1    B3
A1    B3
A2    B1
A2    B1
A2    B4
A3    B2
A3    B2
A5    B1
A5    B1
A5    B6
A5    B4
A6    B2



I want to add extra columns to the dataframe CountID1 and CountID2 which is
the actual count of values such as A1 etc
ie



ID1   ID2    CountID1    CountID2
A1    B3     4           3
A1    B4     4           4
A1    B3     4           3
A1    B3     4           3
A2    B1     3           4
A2    B1     3           4
A2    B4     3           3
A3    B2     2           3
A3    B2     2           3
A5    B1     4           4
A5    B1     4           4
A5    B6     4           1
A5    B4     4           4
A6    B2     1           3


I know this can be done by first creating temporary aggregate dataframes
then merging with the original.
Is there an easier way if i want to calculate many aggregates without having
to merge many temp tables.


Thanks.
-- 
View this message in context: http://www.nabble.com/Adding-columns-of-Aggregates-to-existing-dataframe-tp18039838p18039838.html
Sent from the R help mailing list archive at Nabble.com.



More information about the R-help mailing list