Delete rows with one or more zeros

I have a matrix with 6330 rows and 4 columns (called part1) I wish to delete the rows containing one or more zeros. So for the following rows, row 1 and 3 should be deleted:
4 3 0 2
4 5 2 1
0 0 6 2
1 5 2 5
My guess is that there is 200-400 rows containing one or more zeros. I have tried with (also in loops)
part1(~any(part1,2),:) = [];
but it seem to only delete 15 rows (probably those where all the rows are zeros).
I am quite novel to MATLAB, so thanks for any help.

 Accepted Answer

A = [4 3 0 2
4 5 2 1
0 0 6 2
1 5 2 5] ;
iwant = A(all(A,2),:)

5 Comments

Or:
part1(any(part1 == 0, 2), :) = []
KSSV
KSSV on 24 Apr 2017
Edited: KSSV on 24 Apr 2017
Morten Thomsen commented:
Thanks for the quick answers. To my understanding, KSSVs suggestion is that it forms a new matrix (iwant) including only the rows without any zeros, while Jan Simons simply deletes the rows containing a zero in the old matrix.
However, I have tried them both (as well as in loops) and tried to mess about with them, but they do not seem to work (I examine size before and after). In fact, now no rows are deleted.
A = [4 3 0 2
4 5 2 1
0 0 6 2
1 5 2 5] ;
size(A)
A = A(all(A,2),:) ;
size(A)
@Morton Thomsen: We cannot guess what you are doing. Both codes do exactly what is asked for: Either create a new matrix without rows, which concern zeros, or delete rows, which concern zeros. Both outputs are identical.
If you code does something else, you are running different commands. Then please show them such that we can suggest improvements. Especially if you call such commands in a loop, there are several pitfalls.
Morten Thomsen's "Answer" moved here:
I have messed around with it and works perfectly now. Thanks very much for your help.

Sign in to comment.

More Answers (0)

Categories

Asked:

on 24 Apr 2017

Commented:

on 26 Apr 2017

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!