How to omit zeros while using mean at varfun?

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)

Answer 1

[Walter Roberson]

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.

[Kazi Alam]

thanks!

Answer 2

[KSSV]

Convert zero's to NaN and use nanmean.

[Kazi Alam]

thanks