frequency table with custom bands

?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

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.

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.