Re: [R] Binning groups

From: jim holtman <jholtman_at_gmail.com>
Date: Thu, 22 May 2008 07:35:54 -0400

If you just want to bin the current ages:

> count=c(1, 1, 1, 2, 2, 2, 3, 3, 3, 3, 4, 4, 4, 4, 4, 7, 8, 8, 9, 9,

+ 10, 11, 15, 17, 17, 17, 17, 19, 19, 19, 19, 20, 20, 20, 21, 21,
+ 21, 22, 22, 22, 22, 23, 23, 23, 23, 23, 24, 24, 25, 27, 31, 33
+ )

> age=c(3, 8, 9, 7, 56, 58, 10, 13, 53, 55, 11, 12, 14, 51, 54,
+ 15, 50, 52, 18, 49, 48, 47, 20, 16, 17, 25, 45, 29, 33, 36, 41,
+ 35, 43, 46, 21, 27, 31, 28, 32, 38, 42, 22, 34, 37, 40, 44, 24, + 39, 30, 26, 19, 23)
> # create a vector with each age separately for its count
> bins <- rep(age, times=count)
> # setup the groups for the bins
> groups <- seq(0,100, 10) - 1
> tapply(bins, cut(bins, groups), length)
 (-1,9] (9,19] (19,29] (29,39] (39,49] (49,59] (59,69] (69,79] (79,89] (89,99]

      5 99 222 218 174 34 NA NA NA NA
> # or just the counts
> table(cut(age, groups))

 (-1,9] (9,19] (19,29] (29,39] (39,49] (49,59] (59,69] (69,79] (79,89] (89,99]

      4      10      10      10      10       8       0       0
0       0

>
>

On Thu, May 22, 2008 at 4:19 AM, francogrex <francogrex_at_mail.com> wrote:

>
> Hi, this is probably quite simple but I can't seem to do it correctly. I
> have
> a data frame of counts of infections in different ages; something like:
> count=c(1, 1, 1, 2, 2, 2, 3, 3, 3, 3, 4, 4, 4, 4, 4, 7, 8, 8, 9, 9,
> 10, 11, 15, 17, 17, 17, 17, 19, 19, 19, 19, 20, 20, 20, 21, 21,
> 21, 22, 22, 22, 22, 23, 23, 23, 23, 23, 24, 24, 25, 27, 31, 33
> )
> age=c(3, 8, 9, 7, 56, 58, 10, 13, 53, 55, 11, 12, 14, 51, 54,
> 15, 50, 52, 18, 49, 48, 47, 20, 16, 17, 25, 45, 29, 33, 36, 41,
> 35, 43, 46, 21, 27, 31, 28, 32, 38, 42, 22, 34, 37, 40, 44, 24,
> 39, 30, 26, 19, 23)
>
> frame=data.frame(count, age)
>
> But the data are too grainy and I would like to bin them in age groups
> (that
> I chose) to be something like:
> age<10 ...... count=5
> 10=<age <20 ..... count=8
> etc...
> What is the easiest and quickest way to do this? Thanks
> --
> View this message in context:
> http://www.nabble.com/Binning-groups-tp17399482p17399482.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<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 you are trying to solve?

	[[alternative HTML version deleted]]

______________________________________________
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.
Received on Thu 22 May 2008 - 11:37:52 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 22 May 2008 - 12:30:41 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive