[R] frequency table with custom bands

[jim holtman]

?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: 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.