Delete rows with the same data in the matrix

4 views (last 30 days)
Let's say I have a matrix, and I want to get rid of the duplicates and keep them once, so I can use unique, but I want to get rid of the rows that have the same data but are in different positions and keep them once, so what do I do?
The starting matrix = [1 1;1 2;2 3;4 5;1 1;2 1;3 2];
I want the result = [1 1;1 2;2 3;4 5]; or [1 1;2 1;3 2;4 5];
Can anyone help me with this as I'm completely new with MATLAB. I would be grateful.

Accepted Answer

Jan
Jan on 5 Nov 2022
Edited: Jan on 6 Nov 2022
x = [1 1;2 1;2 3;4 5;1 1;1 2;3 2]; % Swapped [1,2] and [2,1]
sx = sort(x, 2); % Sort the rows:
[ux, ix] = unique(sx, 'rows', 'stable');
% Solution 1: sorted order
ux
ux = 4×2
1 1 1 2 2 3 4 5
% Solution 2: original order
x(ix, :)
ans = 4×2
1 1 2 1 2 3 4 5
  6 Comments
Jan
Jan on 8 Nov 2022
Unfortunately the formerly accepted answer was deleted. Its runtime grows quadratically with the size of the input. Although the code I've suggested is faster, it was valuable to see the different approaches to learn for own implementations.
Chenglin Li
Chenglin Li on 8 Nov 2022
Yes, I thought of using the unique function before, but I didn't sort it.Thank you very much

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!