How can I delete array rows with same numbers
Show older comments
Hello,
I am having trouble finding a way to delete rows in my array with the same numbers.
For example I want to turn X=[123; 234; 213; 435] into X=[123; 234; 435] because rows 1 and 3 have the same numbers.
I've tried coming up with solutions using using "sort" and "unique" but can't quite figure it out. I'll be working with an array around 1225x3 with positive and negative numbers.
Also, every row adds up to equal the same number.
Thanks for any help you guys can give.
Answers (2)
Walter Roberson
on 29 Apr 2012
[sortedrows, ia] = unique(X,'rows');
newX = X(sort(ia,:));
Andrei Bobrov
on 29 Apr 2012
[b b]=unique(sort(X,2),'rows','first');
out = X(sort(b),:)
Categories
Find more on Shifting and Sorting 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!