How to delete duplicates and replace values in an array?

Question

Colin TaylorMays 2021-8-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1437684-how-to-delete-duplicates-and-replace-values-in-an-array

评论： Simon Chan 2021-8-20

Hey, I'm a little stumped on my personal project. I'm trying to have MatLab check a list of ingredients, delete duplicates, and rewrite the remaining ingredient to show how many times its been mentioned. Here's an example:

[("White Onion"),("Potato"),("White Onion"),("Fruit")] -> [("2x White Onion"),("Potato"),("Fruit")]

I know unique() is a command I could use, but how would I rewrite that individual value?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Simon Chan 2021-8-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1437684-how-to-delete-duplicates-and-replace-values-in-an-array#answer_771474

编辑：Simon Chan 2021-8-20

在 MATLAB Online 中打开

Create a table and use function groupsummary

Item=["White Onion";"Potato";"White Onion";"Fruit"];
T=table(Item,'VariableNames',{'Ingredients'});
G = groupsummary(T,"Ingredients","sum")

Result:

G =
  3×2 table
     Ingredients     GroupCount
    _____________    __________
    "Fruit"              1     
    "Potato"             1     
    "White Onion"        2  

3 个评论
显示 1更早的评论隐藏 1更早的评论

Cris LaPierre 2021-8-20

在 MATLAB Online 中打开

Yes. Look at writetable

I would remove the method 'sum', as it doesn't make sense with string data.

ingrT = table(["White Onion","Potato","White Onion","Fruit"]','VariableNames',"ingredients");
groupsummary(ingrT,"ingredients")
ans = 3×2 table
     ingredients     GroupCount
    _____________    __________

    "Fruit"              1     
    "Potato"             1     
    "White Onion"        2     