[R] frequency table with custom bands

arun smartpink111 at yahoo.com
Wed Oct 17 02:45:22 CEST 2012



HI,
May be this helps you:
res<-rbind(as.data.frame(table(cut(Prices,breaks=seq1))),as.data.frame(table(cut(Prices,breaks=seq2))))
res2<-apply(res,2,function(x) gsub("\\(|\\]","",gsub("[,]","-",x)))
res3<-within(as.data.frame(res2),{Freq<-as.numeric(Freq)})
 head(res3)
#   Var1 Freq
#1   0-5    1
#2  5-10    6
#3 10-15    2
#4 15-20    2
#5 20-25    6
#6 25-30    2
A.K.



----- Original Message -----
From: jcrosbie <james at crosb.ie>
To: r-help at r-project.org
Cc: 
Sent: Tuesday, October 16, 2012 7:37 PM
Subject: [R] frequency table with custom bands

I would like to create a frequency table with custom bands. 

seq1 = seq(0, 100, by = 5)
seq2 = seq(100, 1000, by = 100)
Bands = c(seq1, seq2)
Prices = sample(1:1000, 200, replace=F)

How would  I go about find the frequency of prices within each band? 





--
View this message in context: http://r.789695.n4.nabble.com/frequency-table-with-custom-bands-tp4646413.html
Sent from the R help mailing list archive at Nabble.com.

______________________________________________
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.





More information about the R-help mailing list