Grouping data in a table and extracting that section of the table
    조회 수: 5 (최근 30일)
  
       이전 댓글 표시
    
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
답변 (1개)
  Manish Annappa
    
 2017년 7월 12일
        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
참고 항목
카테고리
				Help Center 및 File Exchange에서 Tables에 대해 자세히 알아보기
			
	Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!

