Find the unique pair of coordinates in matrix and depending on the distance matrix, retain the minimum distance matrix and replace the other coordinate pair by NaN

I have two input matrices ( P and R) and a Distance matrix (distance)

P=[1315.2,832.2

1317.2,808.8

1510.8,514.4

1354.7,743

1519.1,873

1382.7,736.6]

R=[1318,816

1318,816

1515,515

1346,740

1515,867

1346,740]

distance= [16.43

7.24

4.2

9.19

7.2

36]

I want to find out unique values of R and from the distance matrices, which ever distance is lesser, retain the R value as per minimum distance between two pairs of coordinates and remaining replace it with NaN

The output should look like this:

P_new=[1315.2,832.2

1317.2,808.8

1510.8,514.4

1354.7,743

1519.1,873

1382.7,736.6]

R_new = [NaN,NaN

1318,816

1515,515

1346,740

1515,867

NaN,NaN]

distance_new = [NaN

7.24

4.2

9.19

7.2

NaN]

% P, R and distance are input matrices
P=[1315.2,832.2;1317.2,808.8;1510.8,514.4;1354.7,743;1519.1,873;1382.7,736.6]
R=[1318,816;1318,816;1515,515;1346,740;1515,867;1346,740]
distance= [16.43;7.24;4.2;9.19;7.2;36]
% P_new, R_new and distance_new are the required output matrices
P_new=[1315.2,832.2;1317.2,808.8;1510.8,514.4;1354.7,743;1519.1,873;1382.7,736.6]
R_new = [NaN,NaN;1318,816;1515,515;1346,740;1515,867;NaN,NaN]
distance_new = [NaN;7.24;4.2;9.19;7.2;NaN]

[KALYAN ACHARJYA]

How to calculate distance matrix?

[JESUS DAVID ARIZA ROYETH]

"I want to find out unique values of R and from the distance matrices, which ever distance is lesser, retain the R value as per minimum distance between two pairs of coordinates and remaining replace it with NaN" What does this mean??

I found the distances between P and R:

16.4402

7.2443

4.2426

9.2027

7.2670

36.8572

but I don't understand what your criteria are to assign NAN

[Praveen GB]

@KALYAN ACHARJYA

distance is calculated as

for i=1:size(P,1)
distance(i)=sqrt((P(i,1)-R(i,1)).^2 + (P(i,2)-R(i,2)).^2)';
end

[Praveen GB]

JESUS DAVID ARIZA ROYETH

for example: 1st and 2nd rows of P have common value of R (1318,816), but distance matrix (16.43 and 7.24).

I want to retain value of R based on minimum distance. Since 7.24 is smallest between 16.43 and 7.24. I want to retain the 2nd row of R as 1318,816 and the other value (1st row of R) i just want to edit as NaN.

Answer 1

[JESUS DAVID ARIZA ROYETH]

a solution:

[uv,~,idx] = unique(R,'rows');
v = accumarray(idx,distance,[],@min);
eliminate=~ismember([R distance],[uv v],'rows');
P_new=P
R_new=R;
R_new(eliminate,:)=nan
distance_new=distance;
distance_new(eliminate)=nan

[Praveen GB]

Thanks JESUS DAVID ARIZA ROYETH.