Find unique rows comparing 2 colums?

4 次查看（过去 30 天）
Ronan
Ronan 2015-9-22
评论： Ronan 2015-9-22
% code
a = [1,200,400;
2,222,410;
3,300,409;
4, 90, 100;
5, 320, 420;
6, 200, 400;
7, 222, 410;
8, 350, 405;
9, 210, 110;
10, 50, 80;]
if you look at the matrix, the first row at column 2 and 3 has values the same as the 6th row. e.g. a(1,2:3) = a(6,2:3). I m trying to return 'a' where it doesn't include duplicates. so the first, second, sixth and seventh row should only have one instance. Previously I just used a nested for loop to take each row and compare it to all other rows but on a larger scale this is computationally expensive. I was trying out the unique function with rows but it only seems to compare individual row elements to one another rather than compare 2 columns of one row to the other rows.

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

采纳的回答

Thorsten
Thorsten 2015-9-22
unique(a(:, 2:end), 'rows')
  3 个评论
显示 1更早的评论
Star Strider
Star Strider 2015-9-22
Add the ‘setOrder’ argument 'stable' to keep the original order:
unique(a(:, 2:end), 'rows', 'stable')
Ronan
Ronan 2015-9-22
my version of matlab doesn't support stable but i found a work around for anybody else wanting to know.
% code
a = [1,200,400;
2,222,410;
3,300,409;
4, 90, 100;
5, 320, 420;
6, 200, 400;
7, 222, 410;
8, 350, 405;
9, 210, 110;
10, 50, 80;]
[b,m,n] = unique(a(:, 2:end), 'rows')
values = zeros(length(b),3)
values(:,2:3) = b
values(:,1) = m
Bop = sortrows(values)

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Resizing and Reshaping Matrices 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by