Calculate average (daily, monthly, seasonally) for long time series data

Hi everyone,

How to use ignore NaN value when calculate mean or geomean using retime?

Thank you.

Answer 1

[Ajay Kumar]

You can ignore NaN values using property omitnan

https://www.mathworks.com/help/matlab/ref/mean.html#buql3m_

[Aries Dwi Siswanto]

Hi Ajay Kumar,

Thank you for your help. I have already used this omitnan, also nanmean when I was applying to retime function (https://www.mathworks.com/matlabcentral/answers/371225-calculate-daily-monthly-annual-averages-from-hourly-data).

Here some synthax that I used:

t = datetime (year, month, day, hour, minute, second);

hourlytemp = timetable(t, TempSurf);

monthlyavg = retime (hourlytemp, 'monthly', 'nanmean')

Error using timetable/retime (line 140)

Unrecognized synchronization method: 'nanmean'.

How to use the nanmean combined to retime?