MATLAB: Comapre arrays of two cells and keep similar arrays

cell arraysMATLABtable

I have 2 cells, A and B; each one containing tables. In the tables, there are a "lat" and "lon" columns. Some "lat" and "lon" columns are similar in both cells. Now I want to compare the table by table each A and B, then in the cell of A save only similar tables (based on "lat" and "lon").

"lat" and "lon" of both tables need to be similar.

Thanks

Best Answer

Try this

load('A.mat')
load('B.mat')
A_lat_lon = cell2mat(cellfun(@(x) {[x.lon(1) x.lat(1)]}, A)');
B_lat_lon = cell2mat(cellfun(@(x) {[x.lon(1) x.lat(1)]}, B)');
idx1 = ismember(A_lat_lon, B_lat_lon, 'rows');
idx2 = ismember(B_lat_lon, A_lat_lon, 'rows');
new_A = A(idx1);
new_B = B(idx2);

Related Solutions

MATLAB: Finding nearest tables based on latitude and longitude columns

Inputs

A is a 1xn or n1x cell array of tables; each table contains the headers 'lat' and 'lon' which are constants.
B is a 1xm or mx1 cell array of tables with the same descrtiption as A.

Output

minIdx is a nx1 vector of index values (positive integers) that identify the tabels listed in B that are closest to A (Euclidean distance). So, the table B(minIdx(i)) is closest to table A(i).

% Function that gets the [lan lon] coordinates for all elements of a cell array.
% input: c is a cell array (ie, A or B), each element is a table with variables "lat" and "lon". 
% Those two columns contain constant values.  
% output: nx2 matrix of [lat,lon] values. 
getLatLon = @(c)cell2mat(cellfun(@(a){[unique(a.lat), unique(a.lon)]},c(:))); 
% Create grid of distances between all stations. 
% distGrid is nxm matrix where distGrid(i,j) is the distance 
% between station i in A and station j in B. 
distGrid = pdist2(getLatLon(A), getLatLon(B)); 
% For each station in A, find the closest station in B.
% minIdx(i) is the index of B closest to station i in A.
[~, minIdx] = min(distGrid,[],2)

You can finish it from here ;)

MATLAB: Trimimg a geotiff by a shapefile

You can use geoimread to read only the data surrounding your shapefile. Get the xdata and ydata from the shapefile, then use those coordinates with geoimread.

Best Answer

Related Solutions

MATLAB: Finding nearest tables based on latitude and longitude columns

MATLAB: Trimimg a geotiff by a shapefile

Related Question