[R] Calculate daily means from 5-minute interval data

Rui Barradas ru|pb@rr@d@@ @end|ng |rom @@po@pt
Sun Aug 29 19:04:54 CEST 2021


I forgot in my previous answer, sorry for the duplicated mails.

The function in my previous mail has a na.rm argument, defaulting to 
FALSE, pass na.rm = TRUE to remove the NA's.

agg <- aggregate(cfs ~ date, df1, fun, na.rm = TRUE)

Or simply change the default. I prefer to set na.rm = FALSE because 
that's what R's functions do. And I will only be used to one default, 
with base R functions or my own code.

Hope this helps,

Rui Barradas

Às 17:52 de 29/08/21, Rich Shepard escreveu:
> On Sun, 29 Aug 2021, Jeff Newmiller wrote:
>> The general idea is to create a "grouping" column with repeated values 
>> for
>> each day, and then to use aggregate to compute your combined results. The
>> dplyr package's group_by/summarise functions can also do this, and there
>> are also proponents of the data.table package which is high performance
>> but tends to depend on altering data in-place unlike most other R data
>> handling functions.
>> Also pay attention to missing data... if you have any then you will need
>> to consider whether you want the strictness of na.rm=FALSE or
>> permissiveness of na.rm=TRUE for your aggregation functions.
> Jeff,
> Thank you. Yes, there are missing data as sometimes the equipment fails, or
> there's some other reason why some samples are missing.
> Grouping on each day is just what I need. I'll re-learn dplyr and take a
> look at data.table.
> Regards,
> Rich
> ______________________________________________
> R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
> 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.

More information about the R-help mailing list