find the number of elements in matrix

2 views (last 30 days)
alireza bakhshaee
alireza bakhshaee on 11 Apr 2018
Answered: Razvan Carbunescu on 11 Apr 2018
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
James Tursa
James Tursa on 11 Apr 2018
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)

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

Categories

Find more on Resizing and Reshaping Matrices 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!