[R] Grouping data
John Kane
jrkrideau at yahoo.ca
Thu Jan 17 15:44:35 CET 2008
You might want to have a look at the recode function
in the car package. By the way I think you meant
26-35 not 25-25.
===================================================
Example
xx <- data.frame(age=c(25, 33, 22, 19,21, 30, 32,
31),
edu=c(2,5 ,3, 1,3, 4, 4, 1))
library(car)
aa <- recode(xx$age, "18:25='A'; 26:35='B'") ; aa
table(xx$edu, aa)
===================================================
--- "K. Elo" <maillists at nic.fi> wrote:
> Hi,
>
> I am quite new to R (but like it very much!), so
> please apologize if
> this is a too simple question.
>
> I have a large data frame consisting of data from a
> survey. There is,
> for example, information about age and education (a
> numeric value from
> 1-9). Now I would like to extract the total amount
> of each type of
> education within different age groups (e.g. from 18
> to 25, from 25 to
> 35 etc.). How could I achieve this? (I have been
> thinking about
> using 'subset', but if there are better ideas they
> are welcome :) )
>
> An example might clarify my point. Let's assume the
> following data:
> # age edu
> 1 25 2
> 2 33 5
> 3 22 3
> 4 19 1
> 5 21 3
> 6 30 4
> 7 32 4
> 8 31 1
>
> What I want to have is:
>
> edu 18-25 25-35 ...
> 1 1 1
> 2 1 0
> 3 2 0
> 4 0 2
> 5 0 1
>
> Thanks in advance & kind regards,
> Kimmo
>
> ______________________________________________
> 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.
>
[[replacing trailing spam]]
More information about the R-help
mailing list