Message-ID: <1349224998.23702.YahooMailNeo@web142603.mail.bf1.yahoo.com>
Date: 2012-10-03T00:43:18Z
From: arun
Subject: add values in one column getting range from other column
In-Reply-To: <1349213154.82094.YahooMailNeo@web161501.mail.bf1.yahoo.com>
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.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.