[R] add values in one column getting range from other column

[arun]

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.