Unique an Array based on one of the columns

4 次查看（过去 30 天）
civil tech
civil tech 2023-4-29
评论： Image Analyst 2023-4-30

I have a table bellow with more than 1000 rows:

The table has six columns. I want to remove the repeated rows with consideration of "Email" column. In another hand, if ithe eamil presents in one row is the same as the email presents in another row, just keep one of these repeated rows (I prefer to keep the last row). How can I do this?

  4 个评论
显示 2更早的评论
Walter Roberson
Walter Roberson 2023-4-29
splitapply(@unique ) with the group determined by the email column (might need findgroups)
civil tech
civil tech 2023-4-29
移动：Walter Roberson 2023-4-29
This command " RR_new= unique(RR.Email) " return a unique table with only one column (email). I need the whole six columns.

请先登录，再进行评论。

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

采纳的回答

Walter Roberson
Walter Roberson 2023-4-29
移动：Image Analyst 2023-4-30
https://www.mathworks.com/matlabcentral/answers/370231-finding-unique-values-in-a-table-without-losing-the-rest-of-the-data#answer_294858
In summary: use the second output of unique() to get the list of indices of table rows to index the table by.
You would not be applying unique to the Email -- you would be applying findgroups() to the email to get the grouping variable for splitapply
  2 个评论
Image Analyst
Image Analyst 2023-4-30
If this Answer solves your original question, then could you please click the "Accept this answer" link to award the answerer with "reputation points" for their efforts in helping you? They'd appreciate it. Thanks in advance. 🙂 Note: you can only accept one answer (so pick the best one) but you can click the "Vote" icon for as many Answers as you want. Voting for an answer will also award reputation points.

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by