How to remove rows with zeros in selected columns?
12 views (last 30 days)
Show older comments
Emma Kuttler
on 24 Feb 2022
Edited: Scott MacKenzie
on 24 Feb 2022
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 Comments
Accepted Answer
Scott MacKenzie
on 24 Feb 2022
Edited: Scott MacKenzie
on 24 Feb 2022
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 ]
zeroIdx = ~sum(~a(:,2:end) == 0,2);
a(zeroIdx,:) = []
0 Comments
More Answers (0)
See Also
Categories
Find more on Get Started with MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!