Merge two matrices taking non-Null values

Question

rosado 2019-2-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/444936-merge-two-matrices-taking-non-null-values

回答： Stephen23 2024-4-4

I have two matrices containing essentially duplicate data, except some values are Null in one but not the other, I need to take the non-Null values from each and combine them into one matrix.

e.g. combine A and B to make C:

A = [8 8 8 8 NaN;

32 32 25 31 NaN;

56 56 43 53 NaN;

81 80 60 76 NaN;

105 103 78 99 NaN;

129 127 95 122 NaN]

B = [8 NaN 8 8 8;

32 NaN 25 31 31;

56 NaN 43 53 53;

81 NaN 60 76 76;

105 NaN 78 99 99;

129 NaN 95 122 121]

C = [8 8 8 8 8;

32 32 25 31 31;

56 56 43 53 53;

81 80 60 76 76;

105 103 78 99 99;

129 127 95 122 121]

Does anyone know if there's a way I can do this?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

madhan ravi 2019-2-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/444936-merge-two-matrices-taking-non-null-values#answer_360998

在 MATLAB Online 中打开

C=zeros(size(A));
C(:,~all(isnan(A)))=A(:,~all(isnan(A)));
C(:,~all(isnan(B)))=B(:,~all(isnan(B)));

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Jose Oliveira 2024-4-4

Very good!

请先登录，再进行评论。

Answer 2

Stephen23 2024-4-4

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/444936-merge-two-matrices-taking-non-null-values#answer_1436651

在 MATLAB Online 中打开

A = [8,8,8,8,NaN;32,32,25,31,NaN;56,56,43,53,NaN;81,80,60,76,NaN;105,103,78,99,NaN;129,127,95,122,NaN];
B = [8,NaN,8,8,8;32,NaN,25,31,31;56,NaN,43,53,53;81,NaN,60,76,76;105,NaN,78,99,99;129,NaN,95,122,121];
C = mode(cat(3,A,B),3)
C = 6x5
     8     8     8     8     8
    32    32    25    31    31
    56    56    43    53    53
    81    80    60    76    76
   105   103    78    99    99
   129   127    95   122   121
<mw-icon class=""></mw-icon>
<mw-icon class=""></mw-icon>