delete zero rows only with one number
2 views (last 30 days)
Show older comments
Dear all, I have a matrix like A =[23 45 23 56;26 0 0 0;45 23 65 34;34 0 0 0] I want a very efficient way to delete only the rows that has zero value from the second column to the end so the result should be
B = [23 45 23 56;45 23 65 34];
Thank you so much,
0 Comments
Accepted Answer
Mohammad Abouali
on 18 Sep 2014
Edited: Mohammad Abouali
on 18 Sep 2014
This will work
A(~any(A'==0),:)
Don't forget " ' " to transpose A in ~any(A ' ==0).
Alternatively if you want to avoid transpose you can do this:
A(~any(A==0,2),:)
If you want just second column and on then
A(~any(A(:,2:end)'==0),:) or A(~any(A(:,2:end)==0,2),:)
Here is how it works
A(:,2:end)==0 generates a logical the same size as A (except that it has one less column). Any entry of A that are zero that A(:,2:end)==0 would be true the rest would be false. Lets call this C=A(:,2:end)==0
now:
any(A(:,2:end)==0,2) is the same as saying any(C,2). This command searches the rows of C and if there is even one true value (i.e. even of A has one zero value on that row) returns true, otherwise it returns false. Lets have D=any(C,2). D would be another logical variable with the same number of elements as the number of rows in A. if that row of A has any zero number in it it would be true, otherwise it would be false.
now
A(~any(A(:,2:end)==0,2),:) is equal to A(~D,:) pretty much returns all columns of A but only those rows of that do not have any zero in it.
This approach will filters any row of A that have even one zero from column 2 to the last column. If you need to filter all those rows that all elements on column2 to the last column are zero just replace "any" with "all".
If you want to filter rows that have different number just change ==0 to ==n where n is your desired number.
0 Comments
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!