How to search and find nearest data in the given array

Question

Triveni 2022-6-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1733620-how-to-search-and-find-nearest-data-in-the-given-array

回答： Voss 2022-6-4

采纳的回答： Voss

array.mat

在 MATLAB Online 中打开

I have an array (Matt J attached)

I have n = 70; or any other number. SP = 998.45 or any other number from column2. I want to search and find corresponding row in column2 contains 998.45 or other number with nearest value of column1 in finded rows with n =70 or any other number. Please help me.

           70          987       984.65          0.1       139.72
           43       987.05        984.6         0.19        89.81
           70       987.05        984.7          0.1       139.72
           70       987.05        984.7          0.1       139.72
           43        987.1       984.65         0.18         89.8
           70        987.1       984.75          0.1       139.72
           43       987.15        984.7         0.18         89.8
           70       987.15        984.8          0.1       139.72
           43        987.2       984.75         0.18         89.8
           70        987.2       984.85          0.1       139.72
           43       987.25        984.8         0.18         89.8
           70       987.25        984.9          0.1       139.72
           43        987.3       984.85         0.18         89.8
...

2 个评论
显示无隐藏无

dpb 2022-6-4

Sorry, the explanation is too disjointed to undersaand.

What would your result be expected to be for the above inputs and, how, precisely would that have been determined to be the correct answer?

Triveni 2022-6-4

There are three rows containing 998.45 in column no. 2.

In these three rows, I want to find nearest value of 70.

请先登录，再进行评论。

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

Answer 1

Voss 2022-6-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1733620-how-to-search-and-find-nearest-data-in-the-given-array#answer_978905

在 MATLAB Online 中打开

array.mat

load('array.mat')
n = 70;
SP = 998.45;
% find the rows where column 2 of array is SP
matching_rows = find(array(:,2) == SP)
matching_rows = 3×1
   541
   542
   543
% find the index of the value nearest to n
% in column 1, among those rows of array
[~,idx] = min(abs(array(matching_rows,1) - n))
idx = 2
% get the value
result = array(matching_rows(idx),1)
result = 62