[R] Binning

jim holtman jholtman at gmail.com
Tue Sep 9 23:18:14 CEST 2008


This should do what you want.

#--x <- read.table('clipboard', header=TRUE, as.is=TRUE)
# convert dates
x$date <- as.POSIXct(strptime(x$SampleDate, "%m/%d/%Y"))
# put ForkLength into bins
x$bins <- cut(x$ForkLength, breaks=c(32, 34, 37, 40), include.lowest=TRUE)
# count the bins
tapply(x$Count, x$bins, sum)
# plot the data
plot(x$date, x$ForkLength, col=c('green', 'red', 'orange')[x$bins])






On Tue, Sep 9, 2008 at 3:12 PM, Felipe Carrillo
<mazatlanmexico at yahoo.com> wrote:
> Dear List:
> I have a dataset with over 5000 records and I would like to put the Count in bins
>  based on the ForkLength. e.g.
>  Forklength   Count
>     32-34        ?
>     35-37        ?
>     38-40        ?
>     and so on...
>     and lastly I would like to plot (scatterplot) including the SampleDate
>     along the X axis and ForkLength along the Y axis. I recently saw an
>      example similar to this one here but I don't want a histogram I      just want to see the ForkLength ranges with different colors. For example:
>      ForkLength 32-34---green
>      ForkLength 35-37---red
>      ForkLength 38-40--Orange
>      Thanks in advance
>
>  SampleDate       ForkLength Count
> 1    12/4/2007         32     2
> 2    12/6/2007         33     1
> 3    12/7/2007         33     2
> 4    12/7/2007         33     2
> 5    12/7/2007         34     1
> 6    12/9/2007         31     1
> 7    12/9/2007         33     2
> 8   12/10/2007         33     5
> 9   12/10/2007         34     1
> 10  12/11/2007         33     2
> 11  12/15/2007         34     1
> 12  12/16/2007         33     2
> 13  12/17/2007         35     1
> 14  12/19/2007         33     1
> 15  12/19/2007         35     1
> 16  12/20/2007         31     1
> 17  12/20/2007         32     1
> 18  12/20/2007         33     1
> 19  12/20/2007         34     3
> 20  12/21/2007         31     1
> 21  12/21/2007         32     3
> 22  12/21/2007         33     4
> 23  12/21/2007         34    11
> 24  12/21/2007         35    16
> 25  12/21/2007         36     3
> 26  12/21/2007         37     1
> 27  12/22/2007         32     1
> 28  12/22/2007         33     3
> 29  12/22/2007         34     1
> 30  12/22/2007         35     2
> 31  12/23/2007         32     1
> 32  12/23/2007         35     1
> 33  12/25/2007         32     1
> 34  12/25/2007         36     1
> 35  12/26/2007         34     1
> 36  12/26/2007         35     2
> 37  12/26/2007         36     1
> 38  12/27/2007         34     4
> 39  12/27/2007         35     2
> 40  12/27/2007         36     2
> 41  12/28/2007         32     1
> 42  12/28/2007         33     1
> 43  12/28/2007         34     1
> 44  12/28/2007         35     3
> 45  12/28/2007         36     4
> 46  12/28/2007         37     6
> 47  12/28/2007         38     2
> 48  12/28/2007         39     2
> 49  12/29/2007         34     1
> 50  12/29/2007         35     5
> 51  12/29/2007         36     2
> 52  12/29/2007         37     1
> 53  12/30/2007         33     3
> 54  12/30/2007         34    10
> 55  12/30/2007         35    10
> 56  12/30/2007         36     6
> 57  12/30/2007         37    15
> 58  12/30/2007         38     3
> 59  12/31/2007         33     3
> 60  12/31/2007         34     8
> 61  12/31/2007         35     9
> 62  12/31/2007         36     6
> 63  12/31/2007         37     3
> 64  12/31/2007         38     1
> 65    1/1/2008         34     6
> 66    1/1/2008         35     6
> 67    1/1/2008         35     1
> 68    1/1/2008         36     6
> 69    1/1/2008         37     9
> 70    1/1/2008         38     1
> 71    1/2/2008         34     2
> 72    1/2/2008         34     1
> 73    1/2/2008         35     2
> 74    1/2/2008         36     2
> 75    1/2/2008         37     2
> 76    1/2/2008         39     1
> 77    1/3/2008         34     3
> 78    1/3/2008         35     3
> 79    1/3/2008         36     2
> 80    1/3/2008         37     3
> 81    1/8/2008         32     1
> 82    1/8/2008         33     7
> 83    1/8/2008         34     6
> 84    1/8/2008         35    10
> 85    1/8/2008         36    16
> 86    1/8/2008         37     7
> 87    1/8/2008         38     1
> 88    1/8/2008         39     1
> 89    1/9/2008         33     1
> 90    1/9/2008         34    20
> 91    1/9/2008         35    49
> 92    1/9/2008         36    49
> 93    1/9/2008         37    39
> 94    1/9/2008         37     1
> 95    1/9/2008         38    18
> 96    1/9/2008         39     1
> 97    1/9/2008         40     1
> 98   1/10/2008         32     3
> 99   1/10/2008         33    13
> 100  1/10/2008         34    56
> 101  1/10/2008         35    33
> 102  1/10/2008         36    24
> 103  1/10/2008         37    18
> 104  1/10/2008         39     1
> 105  1/11/2008         33     7
> 106  1/11/2008         34    46
> 107  1/11/2008         35    41
> 108  1/11/2008         36    28
> 109  1/11/2008         37    29
>
> Felipe D. Carrillo
> Supervisory Fishery Biologist
> Department of the Interior
> US Fish & Wildlife Service
> California, USA
>
> ______________________________________________
> 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
Cincinnati, OH
+1 513 646 9390

What is the problem that you are trying to solve?



More information about the R-help mailing list