Grouping data in a table and extracting that section of the table

Question

John Burford 2017-7-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/347413-grouping-data-in-a-table-and-extracting-that-section-of-the-table

回答： Manish Annappa 2017-7-12

I have a table of data (mixed strings and numbers). I want to extract rows of the table for each unique group of column 1 and 2. I'm having a problem splitting the table by the array "group".

 a = table2array(temp(:,1:1));
 b = table2array(temp(:,2:2));
 ab = strcat(a,'_',b);
 group = findgroups(ab);

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

请先登录，再进行评论。

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

Answer 1

Manish Annappa 2017-7-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/347413-grouping-data-in-a-table-and-extracting-that-section-of-the-table#answer_273915

在 MATLAB Online 中打开

Following document illustrates how to find groups using table variables

https://www.mathworks.com/help/matlab/ref/findgroups.html#bux3e7j

Below code illustrates finding groups based on values from first two columns of the table.

>> T = table([1;2;3;1;2],[1;2;4;1;2],[7;8;9;10;11],'VariableNames',{'One' 'Two' 'Three'});
>> [groups,TID] = findgroups(T(:,1:2))
     groups =
       1
       2
       3
       1
       2
TID = 
      One    Two
      ___    ___
      1      1  
      2      2  
      3      4