Grouping data in a table and extracting that section of the table
8 views (last 30 days)
Show older comments
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 Comments
Answers (1)
Manish Annappa
on 12 Jul 2017
Following document illustrates how to find groups using table variables
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
0 Comments
See Also
Categories
Find more on Tables in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!