# finding equal (lon,lat) in another matrix of different size

5 views (last 30 days)
I have 2 matrices:
A = lon, lat, pressure, temperature
B = lon, lat, depth
A size is bigger than B
I am trying to merge the data from A, B to obtain: (lon, lat, pressure, depth, Temperature)
My logic is:
1. Identify values in which latA=latB AND lonA,lonB
2. export both columns : lon, lat
3. add pressure, depth and temperature values to the final matrix
The problem I face is that I want to
treat (lon, lat) as a one single column so that values do not split(?) like a row
and giving the different size in the two matrices, I want to tell matlab to compare one element (Alat1) with all the elements in B-lat column
I found I could use something like this:
lonMatch = ismember(A(:,1), B(:,1));
latMatch = ismember(A(:,2), B(:,2));
latlonMatch = lonMatch & latMatch; %of course the these 3 lines can be put into 1
Final matrix = A(latlonMatch, 3:end);
I am new to this kind of problem and I do not know how to approach it :(

Johan on 20 Oct 2021
Edited: Johan on 20 Oct 2021
I'm not sure exactly what you mean by A is bigger than B, if you can give a simple example of A and B it would help in helping you :).
I have put a small example below with bogus values maybe this will help. All in all I do somehting very similar to what you proposed.
A = [1, 2, 50, 300; 1, 3, 65, 305]
A = 2×4
1 2 50 300 1 3 65 305
B = [1, 2, 150]
B = 1×3
1 2 150
list = and(abs(A(:,1)-B(:,1))<eps,abs(A(:,2)-B(:,2))<eps); % find matching values
C = A; %initiate final matrix
C(:,end+1) = NaN; %create a new column filled with NaN
C(list,end) = B(list,end) %Replace NaN by values of B in matching rows
C = 2×5
1 2 50 300 150 1 3 65 305 NaN