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

14 次查看（过去 30 天）
Alireza Babaei
Alireza Babaei 2021-4-8
回答： Cris LaPierre 2021-4-8
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?

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

回答（1 个）

Cris LaPierre
Cris LaPierre 2021-4-8
Ran in:
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

类别

在 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!

Translated by