Find repeating rows in a matrix and replace with zeros

Question

Savannah D 2020-11-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/635274-find-repeating-rows-in-a-matrix-and-replace-with-zeros

评论： Monika Jaskolka 2020-11-3

I have a large matrix (5683384x2 double) containing xy-coordinates of an ROI mask. If an xy-coordinate does not repeat enough times, I want to set the row to zeros.

For example if my matrix is [9 10; 9 10; 9 10; 9 10; 9 10; 7 12; 3 4; 3 4; 3 4; 3 4]. I want to replace rows that do not repeat 3 times, so [7 12] would become [0 0]. Is there any way to do this?

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

请先登录，再进行评论。

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

Answer 1

Monika Jaskolka 2020-11-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/635274-find-repeating-rows-in-a-matrix-and-replace-with-zeros#answer_533154

编辑：Monika Jaskolka 2020-11-3

在 MATLAB Online 中打开

This can probably be optimized, but it works to replace rows that don't occur more times than the set threshold, in this case 3 times.

M = [9 10; 9 10; 9 10; 9 10; 9 10; 7 12; 3 4; 3 4; 3 4; 3 4; 7 12];
threshold = 3;
 
[~, ~, ic] = unique(M, 'rows', 'stable');
numOccurances = accumarray(ic, 1);
idxToDelete = false(size(M,1), 1);
for i = 1:length(numOccurances)
    if numOccurances(i) < threshold        
        duplicateRows = find(ic==i);
        idxToDelete(duplicateRows) = true;
    end
end
M(idxToDelete,:) = 0;

If you want to delete the rows entirely, you can replace the last line with this:

M(idxToDelete,:) = []; % Alternatively, delete rows

2 个评论
显示无隐藏无

Savannah D 2020-11-3

编辑：Savannah D 2020-11-3

Thank you! the numOccurances tripped me up at first with my threshold, but this worked great!

Monika Jaskolka 2020-11-3

No problem! If the answer worked for you, please press the "Accept this answer" button.

请先登录，再进行评论。

Answer 2

Bruno Luong 2020-11-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/635274-find-repeating-rows-in-a-matrix-and-replace-with-zeros#answer_533239

编辑：Bruno Luong 2020-11-3

在 MATLAB Online 中打开

M = [9 10; 9 10; 9 10; 9 10; 9 10; 7 12; 3 4; 3 4; 3 4; 3 4; 7 12];
minlgt = 3; % keep all rows consecutively repeated at least minlgt times
i = find([true; any(diff(M,1,1),2); true]);
lgt = diff(i);
removed = lgt<minlgt;
M(repelem(i(removed),lgt(removed)),:) = 0