[R] Binning

Felipe Carrillo mazatlanmexico at yahoo.com
Wed Sep 10 17:45:17 CEST 2008


Thanks Jim and S Ellison for your help

> 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])
> 
> > 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



More information about the R-help mailing list