How to sort a table or Excel file (.xlsx) (.csv) and sort the labels correspondingly?

8 views (last 30 days)
Dear scholars,
I was wondering how to wrtie a code in MATLAB so sort a table based on the magnitude if numbers and then sort/move the corresponding labels as well?
I mean: suppose: a = 1; b= 2; c=3
I nead a table in this format:
a 1
b 3
c 2
Then I need to sort such a table in an ascending fashion in which sorts the labels (a, b, c) as well. The final answer should be:
a 1
c 2
b 3
Any ideas?

Answers (1)

Cris LaPierre
Cris LaPierre on 8 Apr 2021
In MATLAB, you would use sortrows.
name = ["a";"b";"c"];
val = [1;3;2];
T = table(name,val)
T = 3×2 table
name val ____ ___ "a" 1 "b" 3 "c" 2
Tsort = sortrows(T,'val')
Tsort = 3×2 table
name val ____ ___ "a" 1 "c" 2 "b" 3

Categories

Find more on Shifting and Sorting Matrices in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!