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

8 次查看（过去 30 天）
John Burford
John Burford 2017-7-5
回答： 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);

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

回答（1 个）

Manish Annappa
Manish Annappa 2017-7-12
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

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by