Deleting duplicate rows and keeping zero rows?

1 view (last 30 days)
Hi! I need a help!
A=[1 2;
3 4;
0 0;
1 2;
5 6;
0 0]
How can i delete duplicate rows, without deleting zero rows? I want my new matrix to look like that:
A=[1 2;
3 4;
0 0;
5 6;
0 0]
Thank you very much! ;)

Accepted Answer

Stephen23
Stephen23 on 28 Jan 2016
Edited: Stephen23 on 28 Jan 2016
A=[1 2;
3 4;
0 0;
1 2;
5 6;
0 0]
X = ~any(A,2)
[~,Y] = unique(A(~X,:),'rows','stable')
Z = X(~X)
Z(Y) = true
X(~X) = Z
B = A(X,:)
creates this:
B =
1 2
3 4
0 0
5 6
0 0
  1 Comment
Karmen
Karmen on 28 Jan 2016
Thank you 1000 times! I really appreciate your help!;) It works perfectly and the answer is exactly what i was asking for.

Sign in to comment.

More Answers (1)

the cyclist
the cyclist on 28 Jan 2016
Here is another way.
zeroRowIndex = find(~any(A,2)); % Rows with all zeros
[~,uniqueRowIndex] = unique(A,'rows'); % Unique rows (including all-zero rows)
rowsToKeep = union(uniqueRowIndex,zeroRowIndex); % Combine the criteria. [union will discard duplicates by default]
B = A(rowsToKeep,:); % Output

Community Treasure Hunt

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

Start Hunting!