How to remove data points above or below a value in an array, nicely!

7 次查看（过去 30 天）

ljp64 2018-8-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/413197-how-to-remove-data-points-above-or-below-a-value-in-an-array-nicely

评论： OCDER 2018-8-2

In my array (PRE_A, imported from a csv), I want to remove any data point over 900 or below 750, so have written the code below. How do I write this in less lines of code?

Thank you :)

PRE_A = PRE_A(PRE_A(:,2) > 750, :);

PRE_A = PRE_A(PRE_A(:,3) > 750, :);

PRE_A = PRE_A(PRE_A(:,4) > 750, :);

PRE_A = PRE_A(PRE_A(:,5) > 750, :);

PRE_A = PRE_A(PRE_A(:,6) > 750, :);

PRE_A = PRE_A(PRE_A(:,7) > 750, :);

PRE_A = PRE_A(PRE_A(:,8) > 750, :);

PRE_A = PRE_A(PRE_A(:,9) > 750, :);

PRE_A = PRE_A(PRE_A(:,2) < 920, :);

PRE_A = PRE_A(PRE_A(:,3) < 920, :);

PRE_A = PRE_A(PRE_A(:,4) < 920, :);

PRE_A = PRE_A(PRE_A(:,5) < 920, :);

PRE_A = PRE_A(PRE_A(:,6) < 920, :);

PRE_A = PRE_A(PRE_A(:,7) < 920, :);

PRE_A = PRE_A(PRE_A(:,8) < 920, :);

PRE_A = PRE_A(PRE_A(:,9) < 920, :);

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

请先登录，再进行评论。

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

采纳的回答

OCDER 2018-8-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/413197-how-to-remove-data-points-above-or-below-a-value-in-an-array-nicely#answer_331271

编辑：OCDER 2018-8-2

在 MATLAB Online 中打开

I think this is what you're trying to do:

GoodRow = ~any(PRE_A(:, 2:9) <= 750 | PRE_A(:, 2:9) >= 920, 2)
PRE_A = PRE_A(GoodRow, :)

Translation:

GoodRow =    ~        any (PRE_A(:, 2:9) <= 750  |  PRE_A(:, 2:9) >= 920, 2)
Good rows do NOT have any       value <= 750  OR  any value >= 920, across all columns