How can I delete the duplicate rows in cell based on a particular column?

1 次查看（过去 30 天）

SM 2020-8-26

评论： SM 2020-8-26

The input is:

A={[1 2 3] [2 3] [1 2 3];[2 5 8] [3 4] [1 2 3];[2 5 4]  [2 3] [1 2 3];[1 2 5] [3 4] [1 2 3]};

based on the duplication in the 2nd column,the output will be:

B={[2 5 4] [2 3] [1 2 3];[1 2 5] [3 4] [1 2 3]};

How can I do that?

Matt J 2020-8-26

编辑：Matt J 2020-8-26

How do you know which of the duplicates to keep? Why couldn't you keep the first two rows instead of the last two?

SM 2020-8-26

That's really not matter for my case. I just want to delete the duplicate rows based on the 2nd column.

Matt J 2020-8-26

编辑：Matt J 2020-8-26

This assumes the second column always contains vectors of the same length, and also that you want to keep only the last occurence.

[~,idx]=unique(cell2mat(A(:,2)),'rows','last');
B=A(idx,:);

在 Help Center 和 File Exchange 中查找有关 Loops and Conditional Statements 的更多信息

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

Translated by