Message-ID: <1350434722.99300.YahooMailNeo@web142606.mail.bf1.yahoo.com>
Date: 2012-10-17T00:45:22Z
From: arun
Subject: frequency table with custom bands
In-Reply-To: <1350430650231-4646413.post@n4.nabble.com>
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.