How to take average/median of table columns without the zeros?

Hey there, I have a big table (called pm2d), 12 columns by 31 rows, and i need to take the average and median of each column without the zeros being factored in. I know i can use for loop and if statement to check the number of valid data points and get a new array with only valid data points... But every code i try to write is not working. Any assistance would be appreciated! Thanks!

Answer 1

[Adam]

pm2d( a ) ./ sum( logical( pm2d ) );

will give you the mean without taking zeros into account.

If you have a recent version of Matlab then

pm2d( pm2d == 0 ) = NaN;
medianRes = median( pm2d, 'omitnan' );

will give the median (you can actually do the same thing with 'mean' too).

[Leesy]

Awesome thanks!