How to delete duplicates and replace values in an array?
6 views (last 30 days)
Show older comments
Colin TaylorMays
on 20 Aug 2021
Commented: Simon Chan
on 20 Aug 2021
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 Comments
Accepted Answer
Simon Chan
on 20 Aug 2021
Edited: Simon Chan
on 20 Aug 2021
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 Comments
Cris LaPierre
on 20 Aug 2021
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")
Simon Chan
on 20 Aug 2021
Thanks Cris, forgot it is string data.
Use function writetable to put it in a text file
writetable(G,'result.txt')
More Answers (0)
See Also
Categories
Find more on Characters and Strings in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!