How to sort two columns of a data

Question

Abin Krishnan 2014-2-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/115322-how-to-sort-two-columns-of-a-data

编辑： 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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Mischa Kim 2014-2-8

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/115322-how-to-sort-two-columns-of-a-data#answer_123662

编辑：Mischa Kim 2014-2-8

在 MATLAB Online 中打开

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 2014-2-8

Thank you. Can you pls tell how to divide the data

Mischa Kim 2014-2-8

编辑：Mischa Kim 2014-2-8

在 MATLAB Online 中打开

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.

请先登录，再进行评论。