Re: [R] Odp: Problem with aggregating data across time points

2010-07-03 Thread Chris Beeley
Thanks for all your help, that has worked a treat. To answer your questions, I want to include the zero rows because I am going to analyse using mixed models (with dummies for day of week, location etc.) and I thought it was necessary to include a complete list of time variables, but now I'm won

Re: [R] Odp: Problem with aggregating data across time points

2010-07-02 Thread David Winsemius
On Jul 2, 2010, at 11:55 AM, Petr PIKAL wrote: Hi did you try aggregate? aggregate(data[, 5:8],list(data$Date), sum, na.rm=T) Group.1 verbal self.harm violence_objects violence 1 0 000 2 01/04/07 251539 3 02