How to sort two columns of a data
조회 수: 2 (최근 30일)
이전 댓글 표시
I have an excel sheet with two columns:one showing the diameter of the drops and the other the corresponding velocity.I have to divide the data into three categories - 1/3 with small diameters,1/3 with medium diameter and the last 1/3 with large diameter using MATLAB codes.The velocity should also be grouped accordingly.
댓글 수: 0
채택된 답변
Mischa Kim
2014년 2월 8일
편집: Mischa Kim
2014년 2월 8일
A = rand(4,2)
B = sortrows(A)
Once sorted, you can simply access each portion of the sorted matrix B, according to your requirements.
댓글 수: 2
Mischa Kim
2014년 2월 8일
편집: Mischa Kim
2014년 2월 8일
A = rand(13,2);
B = sortrows(A)
[r, c] = size(B);
r_div = floor(r/3);
sec_r = [1 r_div; r_div+1 2*r_div; 2*r_div+1 r];
B_sec2 = B(sec_r(2,1):sec_r(2,2),:)
Some of your data arrays may not be equally dividable into thirds-sections, say, you have 13 measurements. For this case you could, e.g., use the floor command.
r_div = floor(r/3);
which results in the next lower integer of 13/3, which is 4. sec_r is a matrix that holds all the row numbers that "specify" the three sections.
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Shifting and Sorting Matrices에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!