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: r.789695.n4.nabble.com/frequency-table-with-custom-bands-tp4646413.html Sent from the R help mailing list archive at 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: 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 stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
?cut try this:> seq1 = seq(0, 95, by = 5) > seq2 = seq(100, 1000, by = 100) > Bands = c(seq1, seq2) > Prices = sample(1:1000, 200, replace=F) > table(cut(Prices, breaks = Bands))(0,5] (5,10] (10,15] (15,20] (20,25] (25,30] (30,35] (35,40] 1 2 1 1 0 2 1 1 (40,45] (45,50] (50,55] (55,60] (60,65] (65,70] (70,75] (75,80] 1 1 1 1 1 1 1 0 (80,85] (85,90] (90,95] (95,100] (100,200] (200,300] (300,400] (400,500] 1 2 0 1 22 20 17 22 (500,600] (600,700] (700,800] (800,900] (900,1e+03] 25 20 16 18 20> > >On Tue, Oct 16, 2012 at 4:37 PM, jcrosbie <james at crosb.ie> wrote:> 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: 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 > stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code.-- Jim Holtman Data Munger Guru What is the problem that you are trying to solve? Tell me what you want to do, not how you want to do it.