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.sapana at ymail.com>
To: R help <r-help at 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 at 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.