How can I replace value of specific cell value depending on another matrix?

Question

Mohammad Hossain 2018-4-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/392557-how-can-i-replace-value-of-specific-cell-value-depending-on-another-matrix

评论： Mohammad Hossain 2018-4-4

A=[8 3 1; 0 0 0; 7 9 7; 5 5 5; 1 4 5]; D=[5 5 0; 7 9 0]; How can I compare between A and D depending on the first two columns and update the D matrix like,

D_modified=[5 5 5; 7 9 7];

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

请先登录，再进行评论。

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

Answer 1

Birdman 2018-4-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/392557-how-can-i-replace-value-of-specific-cell-value-depending-on-another-matrix#answer_313441

编辑：Birdman 2018-4-4

在 MATLAB Online 中打开

D_modified=A(all(ismember(A(:,1:2),D(:,1:2)),2),:)

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

请先登录，再进行评论。

Answer 2

Akira Agata 2018-4-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/392557-how-can-i-replace-value-of-specific-cell-value-depending-on-another-matrix#answer_313446

在 MATLAB Online 中打开

If some rows in D does not have corresponding rows in A, need some more trick. Here is an example.

% Sample data (1st and 4th row of D has no corresponding row in A)
A = [8 3 1; 0 0 0; 7 9 7; 5 5 5; 1 4 5];
D = [5 4 0; 7 9 0; 8 3 0; 8 2 1];
[~,loc] = ismember(D(:,1:2),A(:,1:2),'rows');
idx = loc ~= 0;
D_modified(idx,:) = A(loc(idx),:);