Re: [R] pivot table in R

From: John Kane <jrkrideau_at_yahoo.ca>
Date: Tue, 29 Jan 2008 10:42:03 -0500 (EST)


Have a look at the reshape package. With your data as data.frame xx :

library(reshape)

dd <- melt(xx, id=c("sex", "age",
"region"),measured=c(no_of_accidents)); dd

cast(dd, sex~variable, sum)

> Hello,
>
> I'm struggling with an elementary problem with R. I
> have a simple data
> frame such as this one giving the number of
> accidents subdivided by sex,
> age and region.
>
> sex age region no_of_accidents
>
> F young north 10
> F young south 12
> F old north 5
> F old south 7
> M young north 24
> M young south 30
> M old north 12
> M old south 17
>
> and I would like to build a pivot table, e.g.
> obtaining the sum of the
> number of accidents for each sex:
>
> sex age region no_of_accidents
>
> F (any) (any) 34
> M (any) (any) 83
>
> but I can't seem to obtain this result simply in R,
> except by embarking in
> complicated "for" loops.
>
> I have checked the documentation on such functions
> as "table()" and the
> documentation on "An introduction to R" but couldn't
> solve the problem.
> Could you please help me with this?
>
> Cheers
>
> Pete
>
>
> PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS
> E-MAIL
>
> For Aon’s standard conditions associated with this
> e-mail please visit
>
http://www.aon.com/uk/en/email-footer/aon-limited.jsp
> Aon Limited
> Registered Office: 8 Devonshire Square, London EC2M
> 4PL
> Registered in London No. 210725 . VAT Registration
> No. 480 8401 48
>
> Aon Limited is authorised and regulated by the
> Financial Services Authority in respect of insurance
> mediation activities only.
>
> [[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.
>



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 Tue 29 Jan 2008 - 15:46:07 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 Tue 29 Jan 2008 - 16:30:09 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