How to calculate count of matching rows and average of specified column of all matching rows

Question

Mekala balaji 2018-6-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/404878-how-to-calculate-count-of-matching-rows-and-average-of-specified-column-of-all-matching-rows

评论： Image Analyst 2018-6-9

Hi,
    I have cell array matrix as below:
    Day                  Name    Score  Status
    2018-01-02 23:04:45  VAH     23     Success
    2018-04-05 13:44:15  BHT     23     Success 
    2018-05-02 14:34:56  HDA07H  12     Success
    2018-05-12 09:34:56  PHA07H  3      Failure
    2018-05-12 09:34:56  HJA07H  34     Failure
    2018-05-23 09:23:46  HOA07H  47     Success
     I want to count the total count of "Success" cases and the average score of success cases in column3
      Day                  Name    Score  Status
      2018-01-02 23:04:45  VAH     23    Success
      2018-04-05 13:44:15  BHT     23    Success 
      2018-05-02 14:34:56  HDA07H  12    Success
      2018-05-23 09:23:46  HOA07H  47    Success
    My desired output is:
    SuccesCount  AvgSuccessScore
    4            26.25
I use below code: do in 4 steps, but can I get it one step?
    Index= strfind(input(:,4), 'Success');
    Index = find(not(cellfun('isempty', Index)));
    AvgSuccessScore=mean(input(Index,3))
    SuccesCount=size(Index,1);

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Paolo 2018-6-9

在 MATLAB Online 中打开

Are two steps acceptable?

 SuccessCount = nnz(strcmp(cellA(:,4), 'Success'));
 AvgSuccessScore=mean(cell2mat(cellA(strcmp(cellA(:,4),'Success'),3)));

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Image Analyst 2018-6-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/404878-how-to-calculate-count-of-matching-rows-and-average-of-specified-column-of-all-matching-rows#answer_323963

I believe so. First, don't use a cell array, use a table. Cell array is not the best form for this data - table is much better. Then simply call grpstats() if you have the Statistics and Machine Learning Toolbox.

2 个评论
显示无隐藏无

Mekala balaji 2018-6-9

Sir,

My Matlab verision is R2012b, is there any way to simplify my code

Image Analyst 2018-6-9

See how grpstats() works with your antique (pre-table) version. The function was there back then and worked somehow. Maybe just use cell2mat() to extract the numerical parts into a matrix.

请先登录，再进行评论。