Unique Function based on 2 columns [Instead of rows]

13 次查看（过去 30 天）
RDG
RDG 2013-4-9
Suppose, I have a cell array, a, with contents as such:
a{1}=[1 3 4 5;
3 3 4 5;
5 5 4 5
2 4 2 6;
6 5 2 6
7 2 3 1;]
How can I apply the 'unique' function on 2 columns [column 3 and 4] such that they will return the value '3' and '2'. [Since there are 3 duplicates for the pair 4,5 and 2 duplicates for the pair 2,6.]
Solution proposed:
diff(find([true; any(diff(a{1}(:,3:4)),2); true]))
-----------------------------------------------------------------------
However, when the arrangement of the contents is changed, for eg.
a{1}=[ 1 3 4 5;
3 3 2 6;
5 5 4 5
2 4 3 1;
6 5 2 6
7 2 3 1;]
The code doesn't seem to identify the similarity/duplicated for column 3 and 4 [Corresponding rows: 1 & 3; 2 & 5; 4 & 6]
  1 个评论
Cedric
Cedric 2013-4-9
No, this code assumes blocks of similar rows (for cols 3 and 4), as it seems to be the case in your first example.

请先登录，再进行评论。

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

采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2013-4-9
b=a{1}
c=b(:,3:4)
[~,idx]=unique(c,'rows','first','stable')
out=b(idx,:)
  4 个评论
显示 2更早的评论
RDG
RDG 2013-4-9
This problem which I'm facing has exposed me to so many new commands in Matlab and logic which I never thought of before. Thank you for your great insight!
Cedric
Cedric 2013-4-9
编辑：Cedric 2013-4-9
Yep, in some sense it is easier to understand how to solve an ODE than to understand how to perform data manipulation efficiently ;-)

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Function Creation 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by