How can I group data in order to build a table?
    조회 수: 2 (최근 30일)
  
       이전 댓글 표시
    
Hello, I want to group values according to the first column which repeats itself in every 5 records and displays the values side by side to build a table like representation. How can I do this? Thanks for the help.    
Input:
11.1000	-0.13104830
11.1005	-0.13109738
11.1010	-0.13113159
11.1015	-0.13115123
11.1020	-0.13115658
11.1000	-0.17104830
11.1005	-0.17779738
...
Output:    
11.1000	-0.13104830 -0.17104830 ...
11.1005	-0.13109738 -0.17779738 ...
11.1010	-0.13113159 -0.23123433 ...
댓글 수: 0
채택된 답변
  Ameer Hamza
      
      
 2020년 10월 1일
        
      편집: Ameer Hamza
      
      
 2020년 10월 1일
  
      Try this
M = [
11.1000	-0.13104830
11.1005	-0.13109738
11.1010	-0.13113159
11.1015	-0.13115123
11.1020	-0.13115658
11.1000	-0.17104830
11.1005	-0.17779738
11.1010	-0.13113159
11.1015	-0.13115123
11.1020	-0.13115658];
[grps, val1] = findgroups(M(:,1));
val2 = splitapply(@(x) {x.'}, M(:,2), grps);
M_out = [val1 cell2mat(val2)];
Result
>> M_out
M_out =
   11.1000   -0.1310   -0.1710
   11.1005   -0.1311   -0.1778
   11.1010   -0.1311   -0.1311
   11.1015   -0.1312   -0.1312
   11.1020   -0.1312   -0.1312
추가 답변 (0개)
참고 항목
카테고리
				Help Center 및 File Exchange에서 LaTeX에 대해 자세히 알아보기
			
	Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!

