How to sort two columns of a data

1 次查看（过去 30 天）
Abin Krishnan
Abin Krishnan 2014-2-8
编辑： Mischa Kim 2014-2-8
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.

请先登录，再回答此问题。

采纳的回答

Mischa Kim
Mischa Kim 2014-2-8
编辑：Mischa Kim 2014-2-8
Abin, use sortrows :
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 个评论
Abin Krishnan
Abin Krishnan 2014-2-8
Thank you. Can you pls tell how to divide the data
Mischa Kim
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 中查找有关 Matrices and Arrays 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by