How to sort a table or Excel file (.xlsx) (.csv) and sort the labels correspondingly?
8 次查看(过去 30 天)
显示 更早的评论
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?
0 个评论
回答(1 个)
Cris LaPierre
2021-4-8
name = ["a";"b";"c"];
val = [1;3;2];
T = table(name,val)
Tsort = sortrows(T,'val')
0 个评论
另请参阅
类别
在 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!