Dealing with NaN values when compressing matrix

3 views (last 30 days)
I have 1000 by 1000 matrix and i want to convert it into a 10x10 matrix, ive found several way on the community that does this. However my matrices contain some cells that are NaN so when the all the values gets added to get averaged for compression the NaN cells force this calculation to yield NaN and so the compressed cell is equal to NaN.
for example if 10 cells are to be averaged and one of them is NaN, is there a way to make it add the 9 values and divide by 9 rather than 10

Accepted Answer

Ameer Hamza
Ameer Hamza on 8 Jun 2020
You can pass omitnan to mean() to ignore NaN values
mean(x, 'all', 'omitnan')
  1 Comment
Ahmed Abdulla
Ahmed Abdulla on 8 Jun 2020
Thank you, i just read about this on the mean documnetation and it worked!

Sign in to comment.

More Answers (0)




Community Treasure Hunt

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

Start Hunting!

Translated by