merging two datasets based on two identical rows in each data set

3 次查看（过去 30 天）
sensation
sensation 2019-11-27
评论： sensation 2019-12-2
Hi,
I am looking to compare two datasets and rearrange their values:
array A:
A=[1 150 234,
1 151 234,
3 151 180,
5 152 345,
4 160 674]; % i should compare in the same time column A(:,2) and A(:,3) with B(:,1) and B(:,2)
B=[151 234 10,
152 345 11,
160 674 10
151 180 1,
150 234 5];
% Result should be:
C=A=[1 150 234 5,
1 151 234 10,
3 151 180 1,
5 152 345 11,
4 160 674 10];
I tried to use ismember but it takes into account only one column of each dataset. I would like to search two identical columns in set B and then merge all data in C as showed in example.
Thanks a lot!

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

采纳的回答

JESUS DAVID ARIZA ROYETH
solution:
[~,n]=ismember(A(:,2:3),B(:,1:2),'rows')
C=[A B(n,end)]

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Whos 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by