How do i delete a repeating row

Question

Emil Sandholt Feld 2022-5-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1713610-how-do-i-delete-a-repeating-row

编辑： Emil Sandholt Feld 2022-5-13

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Cris LaPierre 2022-5-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1713610-how-do-i-delete-a-repeating-row#answer_959195

在 MATLAB Online 中打开

Modified from this example

[C,ia] = unique(grades{:, 1});
B = grades(ia,:)

See this page for alternate ways to access data in a table.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Image Analyst 2022-5-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1713610-how-do-i-delete-a-repeating-row#answer_959075

在 MATLAB Online 中打开

Try this. Adapt as needed

m = [1,2,3;4,5,6;4,5,6;7,8,9]
m = 4×3
     1     2     3
     4     5     6
     4     5     6
     7     8     9
diffRows = diff(m, 1)
diffRows = 3×3
     3     3     3
     0     0     0
     3     3     3
% Delete second row if it's a duplicate and adjacent.
rowsToDelete = find(all(diffRows == 0, 2)) + 1
rowsToDelete = 3
m(rowsToDelete, :) = []
m = 3×3
     1     2     3
     4     5     6
     7     8     9
% Alternatively delete first row if it's a duplicate and adjacent.
% rowsToDelete = find(all(diffRows == 0, 2))
% m(rowsToDelete, :) = []