Hi Ben, let me suggest some background reading - Peter Dalgaard's or Phil Spector's book will set you up with what you need. You can also read one of the many free, contributed sets of notes kept on CRAN.
I hope that this helps Andrew On Mon, Feb 4, 2013 at 8:29 PM, Benjamin Gillespie <gy...@leeds.ac.uk>wrote: > Hi guys, > > I hope you can help me with this (probably) simple query: > > I have a data frame: > > -------------------------- > > a=c(1,1,1,1,1,1,2,2,2,2,2,2) > b=c(1,1,1,2,3,4,1,1,2,2,3,4) > c=c(400,200,300,100,500,300,200,100,500,400,200,100) > > > data=data.frame(a=a,b=b,c=c) > > -------------------------- > > And I would like to get the following output: > > -------------------------- > > b > a 1 2 3 4 > 1 900 100 500 300 > 2 300 900 200 100 > > -------------------------- > > The values in the output represent the sum of values "c" in data frame > "data", for each "a" and "b" combination. > > For example, where "a" = 1 and "b" = 1, the output is 400+200+300 = 900. > > Please would anyone be able to provide a script to create my desired > output? > > Many thanks in advance, > > Ben Gillespie > Research Postgraduate > > School of Geography > University of Leeds > Leeds > LS2 9JT > > > ______________________________________________ > 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. > -- Andrew Robinson Director (A/g), ACERA Senior Lecturer in Applied Statistics Tel: +61-3-8344-6410 Department of Mathematics and Statistics Fax: +61-3-8344 4599 University of Melbourne, VIC 3010 Australia Email: a.robin...@ms.unimelb.edu.au Website: http://www.ms.unimelb.edu.au FAwR: http://www.ms.unimelb.edu.au/~andrewpr/FAwR/ SPuR: http://www.ms.unimelb.edu.au/spuRs/ [[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.