match elements of a matrix to an array

2 次查看（过去 30 天）
SChow
SChow 2020-11-25
编辑： Ameer Hamza 2020-11-25
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) ];

请先登录，再回答此问题。

采纳的回答

Ameer Hamza
Ameer Hamza 2020-11-25
编辑：Ameer Hamza 2020-11-25
A much easier solution is to use interp1() with 'nearest' option
xxx = interp1(B(:,1), B(:,2), A, 'nearest')

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Loops and Conditional Statements 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by