Hi,
I guess this is what you wanted:
dat1<-read.table(text="
Area Percent
456 0
3400 10
79 25
56 18
467 0
67 67
839 85
1120 0
3482 85
",sep="",header=TRUE)
aggregate(dat1$Percent, list(Area = dat1[,"Area"],Range=cut(dat1
$Percent,breaks=c(-Inf,0, 25, 50, 75, 100),
labels=c("<=0", "0-25", "25-50", "50-75", ">75"))),function(x) x)
# Area Range x
#1 456 <=0 0
#2 467 <=0 0
#3 1120 <=0 0
#4 56 0-25 18
#5 79 0-25 25
#6 3400 0-25 10
#7 67 50-75 67
#8 839 >75 85
#9 3482 >75 85
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.
