How to make a list of appearance
5 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Hi guys,
I am having some lists of animal which some animal appear many time in many list. So I want to count the appearance of animal and show how many times it appear, then save it to excel file
the data after saving in excel shoulbe be like this
name , count
a 1
b 3
c 2
I have think about 2d- char array but it seems Matlab does not support it.
0 Commenti
Risposta accettata
Ameer Hamza
il 25 Set 2020
Modificato: Ameer Hamza
il 25 Set 2020
Use findgrpups() and histcounts(). Something like this
names = ["cat" "dog" "cat" "cat" "dog"];
[n, unique_names] = findgroups(names);
freq = accumarray(n(:), 1);
T = table(unique_names(:), freq(:));
Result
>> T
T =
2×2 table
Var1 Var2
_____ ____
"cat" 3
"dog" 2
Write to excel file
writetable(T, 'filename.xlsx')
In R2019a and later, following will also work
names = ["cat" "dog" "cat" "cat" "dog"];
[freq, unique_names] = groupcounts(names(:));
T = table(unique_names(:), freq(:));
6 Commenti
Più risposte (2)
KSSV
il 25 Set 2020
Let str be your list of animals.
xbins = unique(str);
[counts,centres] = hist(str,xbins);
R = [centres counts']
0 Commenti
Steven Lord
il 25 Set 2020
histcounts and histogram can handle categorical arrays.
names = ["cat" "dog" "cat" "cat" "dog"];
animals = categorical(names);
[counts, types] = histcounts(animals);
results = table(types.', counts.', 'VariableNames', ["animal", "population"])
0 Commenti
Vedere anche
Categorie
Scopri di più su 2-D and 3-D Plots in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!