How to omit zeros while using mean at varfun?

7 views (last 30 days)
Hallo, Thanks for reading!
I want to know if this is posssible to omit zeros to calculate mean values using the following line of code?
varfun(@mean, data(indexrows,indexheaders), 'InputVariables', @isnumeric)

Accepted Answer

Walter Roberson
Walter Roberson on 10 Jun 2021
Edited: Walter Roberson on 10 Jun 2021
varfun(@(x)sum(x,1)./sum(x~=0,1), data(indexrows,indexheaders), 'InputVariables', @isnumeric)
This has been designed to be able to handle column-by-column non-zero mean for cases where a table variable might be a 2D array instead of a column vector.

More Answers (1)

KSSV
KSSV on 10 Jun 2021
Convert zero's to NaN and use nanmean.

Tags

Products

Community Treasure Hunt

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

Start Hunting!