Matching matrices based on two columns

Question

SChow 2021-7-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/878523-matching-matrices-based-on-two-columns

编辑： Simon Chan 2021-7-14

I have two matrices A and B, I am trying to match these by 2 columns of B and when they dont match instert Nan as fill value

A=

0.1 0.22 5 82 855
0.22 0.23 58 8 888
0.23 0.25 55 5 958
0.25 0.28 55 8 97
0.29 0.51 33 52 55

and B= (this contains some elements from column 2 and 3 of matrix A

I am trying to have a matrix as follows

NaN 0.01 0.02 NaN NaN NaN
0.1 0.22 5 82 855
0.22 0.23 58 8 888
0.23 0.25 55 5 958
0.25 0.28 55 8 97
NaN 0.28 0.29 NaN NaN NaN
0.29 0.51 33 52 55

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

SChow 2021-7-14

编辑：SChow 2021-7-14

在 MATLAB Online 中打开

I tried the following, the error says "The logical indices in position 1 contain a true value outside of the array bounds."

i=ismember(B,A(:,3:4));
A(i,:)

请先登录，再进行评论。

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

Answer 1

Simon Chan 2021-7-14

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/878523-matching-matrices-based-on-two-columns#answer_746813

编辑：Simon Chan 2021-7-14

在 MATLAB Online 中打开

col=size(A,2);
row=size(B,1);
C = nan(row,col);
[~,idx] = ismember(B,A(:,2:3),'rows');
idx2=find(idx~=0);                              % Index for Member
idx3=find(idx==0);                              % Index for Non-member
idx(idx==0)=[];
C(idx2,:)=A(idx,:);
C(idx3,2:3)=B(idx3,:)