Percentage in tablerows with subgrouping

Question

Janani Thiyagarajan 2017-12-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/370877-percentage-in-tablerows-with-subgrouping

编辑： Guillaume 2017-12-4

I have the following table as shown below; i want to get % of true vs false for each subjID, condition combination; example first row 1,1 false should be 20% and second row should be 80% and so on thanks

subjID    condition    correctAnswer    GroupCount    sum_correctAnswer
    ______    _________    _____________    __________    _________________
       1            false             2             0               
       1            true              8             8               
       2            false             5             0               
       2            true              5             5               
       1            false             3             0               
       1            true              7             7               
       2            false             4             0               
       2            true              5             5               
       1            true             10            10               
       2            false             6             0               
       2            true              4             4               
       1            false             6             0               
       1            true              4             4               
       2            true             10            10               
       1            true             10            10               
       2            false             5             0               
       2            true              4             4               
       1            false             1             0               
       1            true              7             7               
       2            false             5             0               
       2            true              4             4

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

请先登录，再进行评论。

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

Answer 1

KL 2017-12-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/370877-percentage-in-tablerows-with-subgrouping#answer_294530

在 MATLAB Online 中打开

Your last column is the sum of correct answer for every case and you can calculate the percentage of correct answer with that using varfun. Let's say T is your table and now you use varfun to calculate the sum of group_count for every case (true+false). So,

T_percent = varfun(@sum, T, 'GroupingVariables',{'sub_id','condition'});

now the resulting table looks like,

T_percent = 
             sub_id    condition    GroupCount    sum_answer    sum_group_count    sum_sum_count
             ______    _________    __________    __________    _______________    _____________
      1_1    1         1            2             1             10                  8           
      1_2    1         2            2             1             10                  5           
      2_1    2         1            2             1             10                  7           
      2_2    2         2            2             1              9                  5           
      3_1    3         1            1             1             10                 10           
      3_2    3         2            2             1             10                  4           
      4_1    4         1            2             1             10                  4           
      4_2    4         2            1             1             10                 10           
      5_1    5         1            1             1             10                 10           
      5_2    5         2            2             1              9                  4           
      6_1    6         1            2             1              8                  7           
      6_2    6         2            2             1              9                  4

now, you have to simply calculate the percentage of last column with it's previous column to know the percentange of right answers. So,

T_percent.Percent_True = (T_percent{:,end}./T_percent{:,end-1}).*100;

now the table looks like,

T_percent = 
             sub_id    condition    GroupCount    sum_answer    sum_group_count    sum_sum_count    Percent_True
             ______    _________    __________    __________    _______________    _____________    ____________
      1_1    1         1            2             1             10                  8                   80      
      1_2    1         2            2             1             10                  5                   50      
      2_1    2         1            2             1             10                  7                   70      
      2_2    2         2            2             1              9                  5               55.556      
      3_1    3         1            1             1             10                 10                  100      
      3_2    3         2            2             1             10                  4                   40      
      4_1    4         1            2             1             10                  4                   40      
      4_2    4         2            1             1             10                 10                  100      
      5_1    5         1            1             1             10                 10                  100      
      5_2    5         2            2             1              9                  4               44.444      
      6_1    6         1            2             1              8                  7                 87.5      
      6_2    6         2            2             1              9                  4               44.444