Hi Kat,
I was able to replace the brackets.
I guess this will be the results you wanted.
x1<-c(123, 48, 342, 442, 43, 232, 32, 129, 191, 147)
res<-cut(x1,breaks=seq(0,500,by=100))
library(reshape)
res2<-melt(table(res))
colnames(res2)<-c("bin","count")
res3<-as.matrix(res2)
res3<-apply(res3,2,function(x) gsub("\\(|\\]","",x))
res3<-data.frame(apply(res3,2,function(x)gsub("\\,","-",x)))
res3
bin count
1 0-100 3
2 100-200 4
3 200-300 1
4 300-400 1
5 400-500 1
A.K.
----- Original Message -----
From: arun <smartpink...@yahoo.com>
To: Kathryn B Walters-Conte <kbw1...@yahoo.com>
Cc: R help <r-help@r-project.org>
Sent: Monday, June 11, 2012 10:04 PM
Subject: Re: [R] Simple Binning of Values
Hi Kat,
Try this:
x1<-c(123, 48, 342, 442, 43, 232, 32, 129, 191, 147)
res<-cut(x1,breaks=seq(0,500,by=100))
library(reshape)
res2<-melt(table(res))
colnames(res2)<-c("bin","count")
> res2
bin count
1 (0,100] 3
2 (100,200] 4
3 (200,300] 1
4 (300,400] 1
5 (400,500] 1
I am trying to figure out how to get rid of the brackets. Otherwise, the
results looks fine.
A.K.
----- Original Message -----
From: Kathryn B Walters-Conte <kbw1...@yahoo.com>
To: "r-help@r-project.org" <r-help@r-project.org>
Cc:
Sent: Monday, June 11, 2012 5:22 PM
Subject: [R] Simple Binning of Values
Hello
I am very new to R. I have an R task to complete that I have not been able to
find a straightforward answer to as of yet. I have a list of values. I would
like to count the number of values that are in one bin, the number that fall in
the next bin, etc.
For example
My input file is: 123 48 342 442 43 232 32 129 191 147
I would like the output to be similar to:
0-100 3
100-200 4
200-3001
300-400 1
400-5001
Thus far I have tried working with hist, cut and split, but have not gotten
very far.
Thanks
Kat
[[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.
