How to count the total count of each unique occurance

Question

Kanakaiah Jakkula 2016-6-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/287551-how-to-count-the-total-count-of-each-unique-occurance

关闭： MATLAB Answer Bot 2021-8-20

Hi,
I have below Table, and I want to count

Total count of data(just column1)
Total count of passed cases
Total count of failed cases
Total count of struck
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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

此问题已关闭。

Answer 1

the cyclist 2016-6-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/287551-how-to-count-the-total-count-of-each-unique-occurance#answer_224413

在 MATLAB Online 中打开

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)