Info

This question is closed. Reopen it to edit or answer.

How to count the total count of each unique occurance

2 views (last 30 days)
Hi,
I have below Table, and I want to count
  1. Total count of data(just column1)
  2. Total count of passed cases
  3. Total count of failed cases
  4. Total count of struck
  5. Total count of removed cases.
RCP1 passed
RCP4 passed
RCP6 failed
RCP2 passed
RCP2 failed
RCP3 failed
RCP5 passed
RCP2 struck
RCP2 passed
RCP4 passed
RCP4 passed
RCP4 struck
RCP4 removed
Many thanks in advance.

Answers (1)

the cyclist
the cyclist on 4 Jun 2016
Here's one way:
C = {
'passed'
'passed'
'failed'
'passed'
'failed'
'failed'
'passed'
'struck'
'passed'
'passed'
'passed'
'struck'
'removed'};
G = grpstats(table(C),'C');
sum(G.GroupCount)

Community Treasure Hunt

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

Start Hunting!