Unique rows of 2 cells with 2 columns each.

2 次查看（过去 30 天）

显示更早的评论

BdS 2019-9-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/480236-unique-rows-of-2-cells-with-2-columns-each

评论： Guillaume 2019-9-18

采纳的回答： Matt J

I have got 2 cells with 2 columns each:

IdxMembers(1636x2)

IdxMembers2(1630x2)

I am looking of the unique values of each cells in form of (nr. of unique values in first row x 2 columns)

I tried the following 2 codes:

unique(vertcat(IdxMembers,IdxMembers2),'rows')
and
unique(vertcat(IdxMembers,IdxMembers2))

I get the unique values in dim (nr. of unique values x 1 column). However, I would like get the output with the second column.

Do you have any suggestions?

7 个评论
显示 5更早的评论隐藏 5更早的评论

BdS 2019-9-17

I am sorry for the confusion.

I mean as your wrote in your first example. But with the corresponding value in column 1

Thanks

BdS 2019-9-17

The unique values should be based on the information based on column 1

请先登录，再进行评论。

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

采纳的回答

Matt J 2019-9-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/480236-unique-rows-of-2-cells-with-2-columns-each#answer_391710

I tried the following 2 codes: unique(vertcat(IdxMembers,IdxMembers2),'rows')... I get the unique values in dim (nr. of unique values x 1 column).

No, you really should have gotten 2 column output, as in the example below. Something about your situation must be different from what you are describing.

>> [IdxMembers,IdxMembers2] =deal( randi(3,4,2)  , randi(3,3,2))
IdxMembers =
   1
   2
   2
   2
IdxMembers2 =
   3
   2
   1
>> unique(vertcat(IdxMembers,IdxMembers2),'rows')
ans =
   1
   1
   2
   2
   3

更多回答（1 个）

Guillaume 2019-9-17

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/480236-unique-rows-of-2-cells-with-2-columns-each#answer_392282

编辑：Guillaume 2019-9-17

merged = [new; old];  %simpler way to write vertcat(new, old)
[~, row] = unique(merged(:, 1));  %get row index of unique values in the 1st column
result = merged(row, :)  %extract these rows

4 个评论
显示 2更早的评论隐藏 2更早的评论

BdS 2019-9-18

thank you for your explanation.

Option 1 seems to more efficient: 0.007129 seconds in comparison with 0.028908

Guillaume 2019-9-18

Option 1 seems to more efficient: 0.007129 seconds

As long as you consider efficiency to be just the execution speed and that you care about a few milliseconds difference.

Indeed string arrays may have a slight speed impact but if you consider that if you'd used string arrays to start with your original code would have worked straight away but instead it took you 4 days to resolve the problem, in term of development time string arrays would have won hands down.

请先登录，再进行评论。

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