how to merge two matrices via one common column

13 次查看（过去 30 天）
Xin CUI
Xin CUI 2013-6-23
Hi there. My question is that I have two matrices, say, A and B, A have two columns, 1 and 2, B has two columns, 3 and 4. Columns 2 and 3 are actually same numbers, BUT with difference order. How can I merge them together? For example, column 2 of matrix A is [a b c d e f]' and column 3 of matrix B is [d c b a e f]'. All the letters are unique ones. Is there an easy way to merge A and B?
  1 个评论
Matt J
Matt J 2013-6-23
编辑：Matt J 2013-6-23
It is confusing to call the columns of B "3 and 4" if B only has two columns.

请先登录，再进行评论。

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

采纳的回答

Andrei Bobrov
Andrei Bobrov 2013-6-23
[~,ii] = ismember(A(:,2),B(:,1));
out = [A, B(ii,2)];

更多回答（1 个）

Matt J
Matt J 2013-6-23
编辑：Matt J 2013-6-23
Anew=sortrows(A,2);
Bnew=sortrows(B,1);
merged=[Anew,Bnew(:,2)];

类别

在 Help Center 和 File Exchange 中查找有关 Shifting and Sorting Matrices 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by