Delete rows with one or more zeros

1 view (last 30 days)
Morten Thomsen
Morten Thomsen on 24 Apr 2017
Commented: Stephen23 on 26 Apr 2017
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

KSSV
KSSV on 24 Apr 2017
A = [4 3 0 2
4 5 2 1
0 0 6 2
1 5 2 5] ;
iwant = A(all(A,2),:)
  5 Comments
Jan
Jan on 24 Apr 2017
@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.
Stephen23
Stephen23 on 26 Apr 2017
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

Find more on Creating and Concatenating Matrices 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!