Unique an Array based on one of the columns

Question

civil tech 2023-4-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1955199-unique-an-array-based-on-one-of-the-columns

评论： 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更早的评论隐藏 2更早的评论

Walter Roberson 2023-4-29

splitapply(@unique ) with the group determined by the email column (might need findgroups)

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.

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2023-4-29

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1955199-unique-an-array-based-on-one-of-the-columns#answer_1226034

移动：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 个评论
显示无隐藏无

civil tech 2023-4-30

移动：Image Analyst 2023-4-30

Thanks a lot.

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.

请先登录，再进行评论。