How to select two data of minimum above and below

Question

Mekala balaji 2017-9-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/356975-how-to-select-two-data-of-minimum-above-and-below

回答： Star Strider 2017-9-16

采纳的回答： Star Strider

在 MATLAB Online 中打开

Hi,

I have data as below:

2 4.3 0.2 9
7 4.6 1.3 11
7 2.2 4.6 2
2 4.1 3.0 12
4 5.3 2.6 1
1 4.2 2.3 5
3 4.0 2.0 3
3 4.0 2.0 10

Given point is 12. Based on 4th column, I want to select two data above 12, which are minimum values in column 4, two data below 12 (which are minimum, in column 4). My desired output as below:

2 4.3 0.2 9
7 2.2 4.6 2
2 4.1 3.0 12
4 5.3 2.6 1
3 4.0 2.0 3

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Star Strider 2017-9-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/356975-how-to-select-two-data-of-minimum-above-and-below#answer_281818

在 MATLAB Online 中打开

This works:

M = [1.2 4.3 0.2 9
     2.7 4.6 1.3 11
     2.7 2.2 4.6 2
     0.2 4.1 3.0 12
     0.4 5.3 2.6 1
     1.1 4.2 2.3 5
     2.3 4.0 2.0 3
     2.3 4.0 2.0 10];
M12 = find(M(:,4) == 12);                               % Index Of Row With ‘12’ In Column #4
Ma12 = sortrows(M(1:(M12-1),:),4);                      % Sorted Rows Above
Mb12 = sortrows(M((M12+1):end,:),4);                    % Sorted Rows Below
Result = [Ma12(1:2,:); M(M12,:); Mb12(1:2,:)]           % Desired Result
Result =
          2.7          2.2          4.6            2
          1.2          4.3          0.2            9
          0.2          4.1            3           12
          0.4          5.3          2.6            1
          2.3            4            2            3