Delete rows with the same data in the matrix
1 view (last 30 days)
Show older comments
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.
0 Comments
Accepted Answer
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
% Solution 2: original order
x(ix, :)
6 Comments
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.
More Answers (0)
See Also
Categories
Find more on Matrix Indexing 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!