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 <ja...@crosb.ie>
To: r-help@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@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.
