two arrays mapping value

3 次查看（过去 30 天）
Pierre
Pierre 2013-9-25
Hi, I have two arrays A=[1 0.1452; 2.1 0.2487; 3.2 0.3478; 4.8 0.41123] and B=[0.4 0.5 2.5 3.5 1.7]. I wanna get the mapping value of B from A. The rule is to find the ceil value of B in first column of A and return value in second column of A.For example, the ceil value of 1.7 in first column of A is 2.1, so the mapping value is 0.2487. Finally, the mapping value of B is [0.1452 0.1452 0.3478 0.41123 0.2487]. The size of B is over 10000. Please tell me the faster and more efficient method to solve it. Thanks

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

采纳的回答

Vishal Rane
Vishal Rane 2013-9-25
A((A(:,1) == min(A(A(:,1) > B(1)))),2)
  1 个评论
Vishal Rane
Vishal Rane 2013-9-25
编辑：Vishal Rane 2013-9-25
run this in a for loop by indexing B(i) or use this
arrayfun( @(x)( A((A(:,1) == min(A(A(:,1) > x))),2)), B)

请先登录，再进行评论。

更多回答（1 个）

Jan
Jan 2013-9-25
编辑：Jan 2013-9-25
B(B > max(A(:, 1)) = NaN; % B too large
[dummy, index] = histc(B, [-Inf, A(:, 1).']);
outOfRange = (index == 0)
Result = A(index(~outOfRange), 2);
I cannot test this currently. Please care about the exceptions like values of B, which are greater or equal the maximum value of A. The CEIL criterion is not fulfilled, when an element of B is exactly contained in A. But HISTC is the general way to go through.

类别

在 Help Center 和 File Exchange 中查找有关 Matrices and Arrays 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by