Compare two matrix in matlab

31 次查看（过去 30 天）
MCC
MCC 2021-6-15
评论： MCC 2021-6-15
I have two matrix data1 and data2. I want to select all rows in data1 that close or equals to data2. I know that loop each element can work but it will take a long time. Is there any easy method I can use?
data1 is attached and data 2 is the following function.
x1 = (0:1:414194)';
data2 = 6*x1;
Thank a lot,
MCC

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

采纳的回答

SALAH ALRABEEI
SALAH ALRABEEI 2021-6-15
Here you can extract those element val that are in both data located at index1 and index2
[val,index1,index2] = intersect(data1,data2)
  4 个评论
显示 2更早的评论
SALAH ALRABEEI
SALAH ALRABEEI 2021-6-15
Another approach, to find values in a that are close or equal to data in b. Eror 0.001
a=1:10;
b=[3.001,4.99,5,6,10];
[x,y] = meshgrid(a,b);
A = [x(:),y(:)];
index = find(abs(A(:,1)-A(:,2))<1e-3);
x(index) % values in a that are close or equal to data in b
MCC
MCC 2021-6-15
Thanks. This works perfet for my problem.

请先登录，再进行评论。

更多回答（1 个）

Sulaymon Eshkabilov
Easy and fast efficient solution is Logical Indexing, e.g.:
IND = Data1==Data2
D1 = Data1(IND);
D2 = Data2(IND);
You can also employ round() fcn to reduce the small differences in values of the two data sets.
Or even better to compute the min. differences and get those indices, e.g.:
[minVal,ClosestIND] = min(abs(Data1-Data2))
D1 = Data1(ClosestIND);
D2 = Data2(ClosestIND);
  3 个评论
显示 1更早的评论
Sulaymon Eshkabilov
Sulaymon Eshkabilov 2021-6-15
In that case, probably a loop would be an opt.
MCC
MCC 2021-6-15
编辑：MCC 2021-6-15
Yes. Do you have any ideas of how to write this code? The data1 is 47987 by 1 and the data2 is 414195 by 1.
Thanks a lot,
MCC

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by