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 Comment

Please provide a small sample of your table so we can see exactly what is in that 6th column.

Sign in to comment.

Answers (2)

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)
If using R2018a can use groupsummary with the first syntax:
GT = groupsummary(T,6)

Categories

Asked:

on 11 Apr 2018

Answered:

on 11 Apr 2018

Community Treasure Hunt

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

Start Hunting!