Try this:
aggregate(DF[c('data1','data2')], list(gsub('\\..*',
'', DF$time)), FUN sum)
On Mon, Apr 19, 2010 at 12:00 PM, jennyed <jen.wright@ed.ac.uk> wrote:
>
> Hi all,
>
> I have a set of data in hourly time steps with each row identified as
> time data column1 data column2
> 1 9999 9999
> 1.042 9999 9999
> 1.083 9999 9999
> 1.125 9999 9999
> 1.167 9999 9999
> 1.208 9999 9999
> 1.25 9999 9999.....and so on (the
> time column is in fractions of a day)
>
> I want to be able to group the data by day. I managed to do this using:
>
> Day1H = hourlydata[c(1:24),]
>
> but I'd like to be able to create groups for each day without doing
this
> manually for each set of 24 rows.
>
> Any suggestions greatly appreciated
>
> Thanks
>
>
> --
> View this message in context:
> http://n4.nabble.com/Grouping-rows-of-data-by-day-tp2016063p2016063.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> 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.
>
--
Henrique Dallazuanna
Curitiba-Paraná-Brasil
25° 25' 40" S 49° 16' 22" O
[[alternative HTML version deleted]]