[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