Deleting duplicate rows and keeping zero rows?

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! ;)

 Akzeptierte Antwort

Stephen23
Stephen23 am 28 Jan. 2016
Bearbeitet: Stephen23 am 28 Jan. 2016

1 Stimme

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 Kommentar

Karmen
Karmen am 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.

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (1)

the cyclist
the cyclist am 28 Jan. 2016

2 Stimmen

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

Kategorien

Mehr zu Matrices and Arrays finden Sie in Hilfe-Center und File Exchange

Gefragt:

am 28 Jan. 2016

Kommentiert:

am 1 Mär. 2016

Community Treasure Hunt

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

Start Hunting!

Translated by