How can I sort an array with two columns?

4 visualizaciones (últimos 30 días)
PJ
PJ el 8 de Oct. de 2018
Editada: Stephen23 el 8 de Oct. de 2018
If I have an array of student ID in column1 and GPAs in column2
Info = [52211 3.55; 52922 1.79; 51939 3.33; 12140 0.81]
How can I sort the array from the highest GPA to the lowest GPA.

Respuesta aceptada

Stephen23
Stephen23 el 8 de Oct. de 2018
Editada: Stephen23 el 8 de Oct. de 2018
Very simply in one line using sortrows:
>> Info = [52211,3.55;52922,1.79;51939,3.33;12140,0.81]
Info =
52211 3.55
52922 1.79
51939 3.33
12140 0.81
>> Info = sortrows(Info,-2)
Info =
52211 3.55
51939 3.33
52922 1.79
12140 0.81

Más respuestas (2)

KSSV
KSSV el 8 de Oct. de 2018
Info = [52211 3.55; 52922 1.79; 51939 3.33; 12140 0.81] ;
[val,idx] = sort(Info(:,2),'descend') ;
iwant = Info(idx,:)

Kevin Chng
Kevin Chng el 8 de Oct. de 2018
Hi,
Info = [52211 3.55; 52922 1.79; 51939 3.33; 12140 0.81];
[~,I] = sort(Info(:,2),'descend');
Info(I,:);
Done!

Categorías

Más información sobre Matrices and Arrays en Help Center y File Exchange.

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by