Using omitnan in accumarray

I am writing a fuction to resize a timetable by a predetermined duration average. For instance the input is time_average(TT,hours(1)); would output an hourly average. The issue is I have some NaN values so when I use accumarray(x,y,[N'1],@mean) I get a series of mostly NaN values. I cannot use nanmean because I do not have access to its toolbox. I know the mean function can be used to omit nan values with mean(X,'omitnan'), but how can I incorporate that in the accumarray function?

Answer 1

[Rik]

You can either write a wrapper function, or extend the anonymous function:

accumarray(x,y,[N'1],@(x)mean(x,'omitnan'))

or

accumarray(x,y,[N'1],@my_mean_omitnan)
function res=my_mean_omitnan(in)
res=mean(in,'omitnan');
end

[Michael Mueller]

Thank you very much that worked perfectly!