match elements of a matrix to an array

2 views (last 30 days)
Hello,
I have one matrix (A1) of size 4000x8000 and the second matrix (g1) of size 100000x2.
I am trying to match each number in A1 to the nearest number in g1(:,1) and build another matrix (xxx) witn the corresponding element in g1(:,2).
I am tring the following however I get an error
Error using bsxfun
Requested 50001x37324800 (6952.4GB) array exceeds maximum array size preference. Creation of arrays greater than this limit may take a long time and cause
MATLAB to become unresponsive.
The following process works for smaller matrices.
Any help is much appreciated.
g1=readtable('interp.csv');
g=g1{:,:};
s=A1(:)';%%converting A1 to n array
bsxfun(@minus,g(:,1),s);
[~,minRow] = min(abs(bsxfun(@minus,g(:,1),s)));
xxx = [ s.', g(minRow,2:end) ];

Accepted Answer

Ameer Hamza
Ameer Hamza on 25 Nov 2020
Edited: Ameer Hamza on 25 Nov 2020
A much easier solution is to use interp1() with 'nearest' option
xxx = interp1(B(:,1), B(:,2), A, 'nearest')

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by