deleting all rows from column 1 with duplicates in column 2.

2 次查看（过去 30 天）
Rafael Borobio Castillo
评论： Rafael Borobio Castillo 2023-8-1
I have the following Table: Column 1 is the product ID and Column 2 is the previous product ID.
I want to delete all duplicates, so all values that are shown in colum 2 must be deleted from column 1. How can I do this.

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

采纳的回答

Matt J
Matt J 2023-8-1
setdiff(Column1,Column2)
  1 个评论
Rafael Borobio Castillo
Rafael Borobio Castillo 2023-8-1
Thanks it works quite well, at the end I finished using ismember to identificate the position of the duplicates because I need to eliminate this from a larger dataset.
All the best, Rafael

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

产品


版本

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by