How do I use the "omitnan' option for the Mean function when calling the function using the splitapply function?

I would like to use the following command: splitapply(@mean,MyArray,G) but call the @mean function using the "omitnan" option. How can I do that? In this example, MyArray is the array that I would like to apply the mean function to after I have split it into Groups dictated by the G vector

[Madhur Duggar]

Thanks!

[Star Strider]

If my Answer helped you solve your problem, please Accept it!

Answer 1

[Star Strider]

One option:

splitapply(@(x)mean(x,'omitnan'),MyArray,G)

[Star Strider]

If my Answer helped you solve your problem, please Accept it!

[Phoebe Armitage]

How would I use 'omitnan' in this scenario?

varfun(@mean,timetable,'GroupingVariable','Date & Time');

[Star Strider]

Phoebe Armitage —

Probably:

varfun(@(x)mean(x,'omitnan'),timetable,'GroupingVariable','Date & Time');

That should work, although since I didn’t test it, I’m posting it as UNTESTED CODE. (I never tried that with varfun, however I have tried it in similar situations.)

If you have the Statistics and Machine Learning Toolbox, you can use nanmean with only the function handle and not the full anonymous function construction.

[SL: fixed typo Lenaring -> Learning]

[Star Strider]

Steven — Thank you!

We desperately need spell check on Answers posts!

[Phoebe Armitage]

It does work, thank you!

[Star Strider]

Phoebe Armitage —

My pleasure!

(A Vote would be appreciated!)