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) --- [EMAIL PROTECTED] wrote: > 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 Aons 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@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@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.