How to remove repeating rows without unique function?
3 次查看(过去 30 天)
显示 更早的评论
I have a 624x2 matrix of ordered pairs, of which there are some repeating rows that I must remove. Is there a way to remove these repeating rows without using the unique function? Maybe using a for loop? The reason I can't use the unique function is because when I implement this matlab script in Simulink's Matlab Function block, the matrix must be sorted first before using the unique function. I can't sort the matrix because I will lose my ordered pairs and sortrows doesn't solve the issue either because I get the same error from Simulink.
0 个评论
采纳的回答
Cedric
2017-9-25
编辑:Cedric
2017-9-25
Use the 'stable' option:
>> A = randi( 3, 10, 2 )
A =
2 3
1 1
3 1
3 1
3 1
3 3
3 3
2 1
2 3
1 1
>> unique( A, 'rows' )
ans =
1 1
2 1
2 3
3 1
3 3
>> unique( A, 'rows', 'stable' )
ans =
2 3
1 1
3 1
3 3
2 1
8 个评论
Cedric
2017-9-26
My pleasure. The amount of unsupported features seems to be a real pain, good luck with the rest!
更多回答(1 个)
Jan
2017-9-26
编辑:Jan
2017-9-26
I still do not understand, why you cannot simply sort the data. But this might be useful:
!!! UNTESTED !!!
function Data = UniqueRows2(Data)
nRow = size(Data, 1);
keep = true(nRow, 1);
for k1 = 1:nRow
if keep(k1)
for k2 = k1 + 1:nData
if keep(k2)
% For rows of length 2:
keep(k2) = (Data(k2, 1) ~= Data(k1, 1)) | (Data(k2, 2) ~= Data(k1, 2));
% General row length:
% keep(k2) = any(bsxfun(@ne, Data(k2, :), Data(k1, :)), 2);
end
end
end
end
Data = Data(keep, :);
end
This might be faster with vectorization:
function Data = UniqueRows(Data)
nRow = size(Data, 1);
keep = true(nRow, 1);
for k1 = 1:nRow
if keep(k1)
keep(k1 + 1:nData) = and(keep(k1 + 1:nData), ...
any(bsxfun(@ne, Data(k2, :), Data(k1, :)), 2));
end
end
Data = Data(keep, :);
end
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Naming Conventions 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!