How to remove repeating elments from a matrix?

1 Ansicht (letzte 30 Tage)
Pushkar Satish Marathe
Pushkar Satish Marathe am 3 Nov. 2017
Kommentiert: Cedric am 3 Nov. 2017
I have following matrix.
A =
1 2 2 1 3
2 1 3 1 1
Where, first two columns are in principle are unique combinations. I would like to remove one column, either 1st or 2nd, and generate following matrix
B =
2 2 1 3
1 3 1 1
OR
B =
1 2 1 3
2 3 1 1
I tried using following
[G,ia,ic] = unique(A(:,1:2),'rows');
uA = A(ia,:)
but it doesn't solve the problem and gives following solution
uA =
1 2 2 1 3
2 1 3 1 1

Akzeptierte Antwort

Cedric
Cedric am 3 Nov. 2017
Bearbeitet: Cedric am 3 Nov. 2017
Almost, the idea was correct but you were not working on the correct dimension. Also, sorting the input array vertically makes columns composed of the same elements identical regardless of their order:
>> [~, ia] = unique( sort(A, 1).', 'rows', 'stable' ) ;
>> B = A(:, ia)
B =
1 2 1 3
2 3 1 1
  2 Kommentare
Pushkar Satish Marathe
Pushkar Satish Marathe am 3 Nov. 2017
Worked very well !! Thanks a lot :)
Cedric
Cedric am 3 Nov. 2017
My pleasure!

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Kategorien

Mehr zu Creating and Concatenating Matrices finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by