Sapana Lohani
2012-Oct-02 21:25 UTC
[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]]
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.
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.