Grouping data in a table and extracting that section of the table
21 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Antworten (1)
Manish Annappa
am 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 Kommentare
Siehe auch
Kategorien
Mehr zu Tables finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!