HI, Infact, there is no need for aggregate(). dat1$range<-cut(dat3$Percent,breaks=c(-Inf,0,25,50,75,100),labels=c("<=0","0-25","25-50","50-75",">75")) dat1 # Area Percent range #1 456 0 <=0 #2 3400 10 0-25 #3 79 25 0-25 #4 56 18 0-25 #5 467 0 <=0 #6 67 67 50-75 #7 839 85 >75 #8 1120 0 <=0 #9 3482 85 >75 A.K.
----- Original Message ----- From: Sapana Lohani <lohani.sap...@ymail.com> To: R help <r-help@r-project.org> Cc: Sent: Tuesday, October 2, 2012 5:25 PM Subject: [R] add values in one column getting range from other column Hi, My dataframe has two columns one with area and other with percent. How can i add the areas that are within a range of percentage?? My dataframe looks like Area Percent 456 0 3400 10 79 25 56 18 467 0 67 67 839 85 1120 0 3482 85 I want to add the area for values whose percent is <0, 0-25, 25-50, 50-75, >75. How can I do that??? [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.