How do i delete a repeating row
1 view (last 30 days)
Show older comments
Emil Sandholt Feld
on 7 May 2022
Edited: Emil Sandholt Feld
on 13 May 2022
Hello guys
I am trying to delete rows that has the same string value in collumn 1, but when I run the script nothing changes. Does anybody know what is wrong?
0 Comments
Accepted Answer
Cris LaPierre
on 7 May 2022
Modified from this example
[C,ia] = unique(grades{:, 1});
B = grades(ia,:)
0 Comments
More Answers (1)
Image Analyst
on 7 May 2022
Try this. Adapt as needed
m = [1,2,3;4,5,6;4,5,6;7,8,9]
diffRows = diff(m, 1)
% Delete second row if it's a duplicate and adjacent.
rowsToDelete = find(all(diffRows == 0, 2)) + 1
m(rowsToDelete, :) = []
% Alternatively delete first row if it's a duplicate and adjacent.
% rowsToDelete = find(all(diffRows == 0, 2))
% m(rowsToDelete, :) = []
0 Comments
See Also
Categories
Find more on Workspace Variables and MAT-Files 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!