Help using grpstats function to get number of occurances per row on a table.

Question

Ajpaezm 2021-4-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/816060-help-using-grpstats-function-to-get-number-of-occurances-per-row-on-a-table

评论： Adam Danz 2021-4-29

I have the following table (4 rows, column names are simply "Col1", "Col2" and so on), for which I'd like to apply grpstats function on.

'China','Hong Kong', '', 'China'
'', 'Switzerland', '',	'Switzerland'
'United States', 'Ireland', '',	'United States'
'Finland', 'Finland', 'Sweden',	''

What I would like to do is to get is the most repeated observation across the rows, using such function without needing to use a combination of accumaray, categorical and unique.

How may I use it? Can you help please?

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

Ajpaezm 2021-4-28

Hello Adam, thanks for your input.

Let me rephrase the question a bit: What I intend to do with grpstats is to make a count of the occurances across the rows of my array first (this is where I think grpstats can be useful). Later on is just on me to check or select the highest number of occurances.

I've edited my question to avoid confusion.

Adam Danz 2021-4-29

My answer uses groupcounts which does not rely on having the stats & machine learning toolbox, unlike grpstats.

请先登录，再进行评论。

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

Answer 1

Adam Danz 2021-4-28

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/816060-help-using-grpstats-function-to-get-number-of-occurances-per-row-on-a-table#answer_687250

在 MATLAB Online 中打开

C = {'China','Hong Kong', '', 'China'
    '', 'Switzerland', '',	'Switzerland'
    'United States', 'Ireland', '',	'United States'
    'Finland', 'Finland', 'Sweden',	''};
rowNum = repmat((1:size(C,1))', 1, size(C,2));
T = table(C(:),rowNum(:),'VariableNames',{'Country','RowNum'});
B = groupcounts(T,{'RowNum','Country'})
B = 11×4 table
    RowNum         Country         GroupCount    Percent
    ______    _________________    __________    _______

      1       {0×0 char       }        1          6.25  
      1       {'China'        }        2          12.5  
      1       {'Hong Kong'    }        1          6.25  
      2       {0×0 char       }        2          12.5  
      2       {'Switzerland'  }        2          12.5  
      3       {0×0 char       }        1          6.25  
      3       {'Ireland'      }        1          6.25  
      3       {'United States'}        2          12.5  
      4       {0×0 char       }        1          6.25  
      4       {'Finland'      }        2          12.5  
      4       {'Sweden'       }        1          6.25  