# [R] Binning the data based on a value

R. Michael Weylandt michael.weylandt at gmail.com
Mon Dec 5 21:43:52 CET 2011

```Just a clarification: I can't get round to work as I first expected so
if you want to do bins by 100's you'd probably want:

split(a, cut(a\$spending, breaks = (0:5)*100))

Michael

On Mon, Dec 5, 2011 at 3:41 PM, R. Michael Weylandt
<michael.weylandt at gmail.com> wrote:
> I'd so something like
>
> split(a, a\$spending)
>
> and you can include a round(a\$spending, -2) or something similar if
> you want to group by the 100's.
>
> Michael
>
> On Mon, Dec 5, 2011 at 3:37 PM, Diviya Smith <diviya.smith at gmail.com> wrote:
>> Hello there,
>>
>> I have a matrix with some data and I want to split this matrix based on the
>> values in one column. Is there a quick way of doing this? I have looked at
>> cut but I am not sure how to exactly use it?
>> for example:
>>
>> I would like to split the matrix "a" based on the spending such that the
>> data is binned groups [0..99],[100..199]...and so on.
>>
>> a <- data.frame(patient=1:7, charges=c(100,500,200,90,400,500,600),
>>  age=c(0,3,5,7,10,16,19),  spending=c(10, 60, 110, 200, 250, 400, 450))
>>
>> Expected  output -
>> bin[1] <- c(10, 60)
>> bin[2] <- c(110, 200, 250)
>> bin[3] <- c(400, 450)
>>
>> NOTE that the number of data points in each bin is not the same and the
>> empty bins are removed (since there are no points between [199..299],
>> bin[3] starts at 400.
>>
>> Any help would be most appreciated. Thank you in advance.
>>
>> Diviya
>>
>>        [[alternative HTML version deleted]]
>>
>> ______________________________________________
>> R-help at r-project.org mailing list
>> https://stat.ethz.ch/mailman/listinfo/r-help
>> and provide commented, minimal, self-contained, reproducible code.

```