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

34 views (last 30 days)
Hi everyone,
How to use ignore NaN value when calculate mean or geomean using retime?
Thank you.

Answers (1)

Ajay Kumar
Ajay Kumar on 24 Apr 2020
You can ignore NaN values using property omitnan
  1 Comment
Aries Dwi Siswanto
Aries Dwi Siswanto on 24 Apr 2020
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?

Sign in to comment.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!