Delete rows only if there are at least a repeated zero value in the previous or next row of the same column

Question

Miguel L 2016-9-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/304382-delete-rows-only-if-there-are-at-least-a-repeated-zero-value-in-the-previous-or-next-row-of-the-same

评论： Andrei Bobrov 2016-9-25

I need your help fellows. I want to remove all rows which contain at least a repeated zero value in the previous/next row of the second column. Look at the next example:

Input=

2  8.6  7.2  -4.8
1  1.8  1.4  -1.2
9  0.0  0.0  0.0
0  0.0  0.0  0.0
0  3.0  3.0  3.0
0  0.0  0.0  0.0
0  3.1  4.0  5.6
0  1.0  231.0  122.0
0  0.0  0.0  0.0
0  0.0  0.0  0.0
0  0.0  0.0  0.0
0  0.0  0.0  0.0

Output=

2  8.6  7.2  -4.8
1  1.8  1.4  -1.2
0  3.0  3.0  3.0
0  0.0  0.0  0.0
0  3.1  4.0  5.6
0  1.0  231.0  122.0

Only it was maintened the sixth row of the original table (input) due to there was not a zero in the previous/next row of the same column (second column).

Thanks in advance for your help!

3 个评论
显示 1更早的评论隐藏 1更早的评论

Miguel L 2016-9-25

在 MATLAB Online 中打开

Walter thanks for your comments. Let me clarify the issue: It is necessary remove rows looking for zeros at the previous/next row of the second column. At the end, I am looking for the result enlisted at the output:

Output=

2  8.6  7.2  -4.8
1  1.8  1.4  -1.2
0  3.0  3.0  3.0
0  0.0  0.0  0.0
0  3.1  4.0  5.6
0  1.0  231.0  122.0

Walter Roberson 2016-9-25

在 MATLAB Online 中打开

Your line

131.1 1.8 1.4 -1.2

is followed by a line that has 0 in its second column, so according to your rules it should be removed.

Perhaps you want the rule to be that if there is a set of rows in which there are at least two rows in a row with 0 in the second column, that the entire block with zeros there should be removed ?

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2016-9-25

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/304382-delete-rows-only-if-there-are-at-least-a-repeated-zero-value-in-the-previous-or-next-row-of-the-same#answer_235991

在 MATLAB Online 中打开

Assuming that the rule is that if there is a set of rows in which there are at least two rows in a row with 0 in the second column, that the entire block with zeros there should be removed, then:

mask1 = input(:,2) ~= 0;
mask2 = mask1(1:end-1) | mask1(2:end);
keep_row = [true;mask2] & [mask2;true];
output = input(keep_row, :);

2 个评论
显示无隐藏无

Miguel L 2016-9-25

Thanks Walter it works perfectly!

Andrei Bobrov 2016-9-25

+1

请先登录，再进行评论。

Delete rows only if there are at least a repeated zero value in the previous or next row of the same column

3 个评论
显示 1更早的评论隐藏 1更早的评论

采纳的回答

2 个评论
显示无隐藏无

更多回答（0 个）

另请参阅

类别

标签

产品

Community Treasure Hunt

Delete rows only if there are at least a repeated zero value in the previous or next row of the same column

3 个评论 显示 1更早的评论隐藏 1更早的评论

采纳的回答

2 个评论 显示 无隐藏 无

更多回答（0 个）

另请参阅

类别

标签

产品

Community Treasure Hunt

WeChat

3 个评论
显示 1更早的评论隐藏 1更早的评论

2 个评论
显示无隐藏无