Calculating Mean of Columns with NaN Values in Matrix A

[member 428835]

Hi PF!

Given a matrix A = [1 2; nan 3; 3 4], how can I calculate the mean so that the resulting matrix averages the columns but ignores the nan values as non-entries, so that the mean of matrix A outputs [2,3]?

Thanks so much!

 

[Wrichik Basu]

>> A = [1 2; nan 3; 3 4];
>> avg = mean(A, 1, 'omitnan')

avg =

     2     3

See https://in.mathworks.com/help/matlab/ref/mean.html#buql3m_

 

[member 428835]

Hey thanks Wrichik Basu! Big help! I appreciate your time!