How to remove rows with zeros in selected columns?

Question

Emma Kuttler 2022-2-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1657945-how-to-remove-rows-with-zeros-in-selected-columns

编辑： Scott MacKenzie 2022-2-24

I have a matrix with 1363 rows and 21 columns. The first column is an identifier (1-21). I need to delete all rows that contain all zeroes with the exception of the first column. For example,

a = [ 1 0 5 0 6

2 0 0 0 0

3 3 5 9 12

4 0 0 0 0

5 6 9 1 0]

I want to produce b

b = [ 1 0 5 0 6

3 3 5 9 12

5 6 9 1 0]

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

请先登录，再进行评论。

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

Answer 1

Scott MacKenzie 2022-2-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1657945-how-to-remove-rows-with-zeros-in-selected-columns#answer_903965

编辑：Scott MacKenzie 2022-2-24

在 MATLAB Online 中打开

There is probably a simpler solution, but this will work...

a = [ 1 0 5 0 6
      2 0 0 0 0
      3 3 5 9 12
      4 0 0 0 0 ]
a = 4×5
     1     0     5     0     6
     2     0     0     0     0
     3     3     5     9    12
     4     0     0     0     0
zeroIdx = ~sum(~a(:,2:end) == 0,2);
a(zeroIdx,:) = []
a = 2×5
     1     0     5     0     6
     3     3     5     9    12