[R] Summing identical IDs

PDXRugger J_R_36 at hotmail.com
Thu Oct 29 20:03:37 CET 2009


Hello All, 
   I would like to select records with identical IDs then sum an attribute
then and return them to the data frame as a single record.  Please consider


Acres<-c(100,101,100,130,156,.5,293,300,.09)
Bldgid<-c(1,2,3,4,5,5,6,7,7)

DF=cbind(Acres,Bldgid)
DF<-as.data.frame(DF)

So that:

  Acres Bldgid
1 100.00      1
2 101.00      2
3 100.00      3
4 130.00      4
5 156.00      5
6   0.50      5
7 293.00      6
8 300.00      7
9   0.09      7

Becomes

  Acres Bldgid
1 100.00      1
2 101.00      2
3 100.00      3
4 130.00      4
5 156.50      5
7 293.00      6
8 300.09      7

dup<-unique(DF$Bldgid[duplicated(Bldgid)])
dupbuild<-DF[DF$Bldgid %in% dup,]
dupbuild..dupareasum<-sum(dupbuild$Acres[duplicated(dupbuild$Bldgid)])

This sums the unique Ids of the duplicated records, not whati want.  Thanks
ahead of time

JR


-- 
View this message in context: http://www.nabble.com/Summing-identical-IDs-tp26118922p26118922.html
Sent from the R help mailing list archive at Nabble.com.




More information about the R-help mailing list