Choosing the role of NaN elements in the sum environment of matrices
Show older comments
Hello everyone
I would like to know what would be the best way to add element by element two matrices, a and b, which, for simplicity, could be defined as:
aa=[1 2; 3 NaN];
bb=[NaN 1; 2 NaN];
adding some conditions: i) if two elements in position (i,j) are different from NaN, add them and divide by the number of elements in that position other than NaN (for example, for position (2,2): (2+1)/2, and for position (1,1): 1/1), and ii) if two elements in position (i,j) are equal to NaN, the sum goes to NaN. So I was wondering which will be the an efficient way to do aa+bb under the i) and j) conditions to obtain:
cc=[1 3/2; 5/2 NaN];
Answers (1)
aa=[1 2; 3 NaN];
bb=[NaN 1; 2 NaN];
cc = mean(cat(3, aa, bb), 3)
2 Comments
aa = [1,2; 3,NaN];
bb = [NaN,1; 2,NaN];
cc = mean(cat(3, aa, bb), 3, 'omitnan')
Chunru
on 25 Mar 2024
Yes. It should be with 'omitnan' option.
Categories
Find more on NaNs in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!