Compare two matrix in matlab

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]

what is the matrices size of data1 and data2!

Answer 1

[SALAH ALRABEEI]

Here you can extract those element val that are in both data located at index1 and index2

[val,index1,index2] = intersect(data1,data2)

[MCC]

Hi, I tried to used this method. But it will extract only part of the data. Any ideas?

Thanks.

[SALAH ALRABEEI]

it will extrac the common values, what else do you want to get!

[SALAH ALRABEEI]

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]

Thanks. This works perfet for my problem.

Answer 2

[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);

[MCC]

Hi Sulaymon,

The rows of data1 and data2 are not identical. So it makes this diffcult to handle.

[Sulaymon Eshkabilov]

In that case, probably a loop would be an opt.

[MCC]

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