[R] Query about calculating the monthly average of daily data columns

Rui Barradas ru|pb@rr@d@@ @end|ng |rom @@po@pt
Thu Sep 12 17:38:27 CEST 2019


Please include data, say

dput(head(data, 20))  # post the output of this

But, is the problem as simple as

rowMeans(data[2:3], na.rm = TRUE)


Hope this helps,

Rui Barradas

Às 15:53 de 12/09/19, Subhamitra Patra escreveu:
> Dear R-users,
> I have daily data from 03-01-1994 to 29-12-2000. In my datafile, he first
> column is date and the second and third columns are the returns of the
> country A, and B. Here, the date column is same for both countries. I want
> to calculate the monthly average of both country's returns by using a loop,
> and then, I want to export the results into excel.
> Please help me in this regard.
> Please find the attached datasheet.
> Thank you.

More information about the R-help mailing list