Calculating the differences between XY pairs in a matrix

Hello friends,

I have this mega matrix (1000:4) with observations that has 0 and 1 on the last column.

The second and third column contains the observations' x,y coordinates in m distance. I want to create a condition where it can output the rows that include 0, satisfy the condition that the measured distance between an observation of 0 and 1 that were less than 5m and then count the no. of observations that satisfied both conditions.

How could I list them out? I realise that the essential functions that I can use could be for loop, count and else if.

Thanks.

Answer 1

[Matt J]

xy=M1(:,2:3);
b=M1(:,4);

A=xy(:,b==0);
B=xy(:,b==1);

tf = any(pdist2(A,B)<=5,2);

result=A(tf,:);

[Naruto]

Thanks Matt!

[Matt J]

You're quite welcome, but please Accept-click the answer to indicate that it solved the problem.