find the number of elements in matrix

I have a table which contains 6 columns. In the 6th column, I have 3 types data: A , Ae , M I want to find: how many A, how many Ae and how many M I have in this column.

1 commentaire

James Tursa
James Tursa le 11 Avr 2018
Please provide a small sample of your table so we can see exactly what is in that 6th column.

Connectez-vous pour commenter.

Réponses (2)

Guillaume
Guillaume le 11 Avr 2018
Should work regardless of the type of data in the 6th column:
[id, group] = findgroups(yourtable.nameof6column)
count = accumarray(id, 1);
%for pretty display
result = table(group, count)
Razvan Carbunescu
Razvan Carbunescu le 11 Avr 2018
If using R2018a can use groupsummary with the first syntax:
GT = groupsummary(T,6)

Catégories

Community Treasure Hunt

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

Start Hunting!

Translated by