How to sort the data with respect to a column in matlab

114 次查看（过去 30 天）
satendra kumar
satendra kumar 2012-11-6
评论： Ameetha 2022-9-19
Lets say....A matrix PhysicalData is a 18X12 matrix. And i want to sort all the rows, in the ascending order of value in any column (Lets say 15th column). So the Row corresponding to the lowest value in 15th column should come first and so on. Please help me out. Thanks

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

采纳的回答

Thomas
Thomas 2012-11-6
doc sortrows
Suppose you want to sort matrix A according to the 15th column you would use
out=sortrows(A,15)

更多回答（1 个）

Ameetha
Ameetha 2022-9-19
How to sort a table based on a particular column in ascending order whose elements are names of images saved in the order 1.jpg,2.jpg...... When sortrows command is used its getting sorted as 1.jpg, 10.jpg, 100.jpg etc
  5 个评论
显示 3更早的评论
Stephen23
Stephen23 2022-9-19
编辑：Stephen23 2022-9-19
The NATSORTROWS documentation states that the second input argument is reserved for specifying a regular expression (if used). This is explained in the Mfile help and in the HTML help.
To specify the table variable/column name to sort, then this can be provided as input 3 (or greater):
Data1 = natsortrows(Data, [], 'ImageName');
An alternative approach is to sort that variable/column using NATSORTFILES and then use the sort index to sort the table into the same order:
[~,idx] = natsortfiles(Data.ImageName);
Data1 = Data(idx,:)
https://www.mathworks.com/matlabcentral/fileexchange/47434-natural-order-filename-sort
Ameetha
Ameetha 2022-9-19
[~,idx] = natsortfiles(Data.ImageName);
Data1 = Data(idx,:)
Thanks a lot. It actually worked. Thank you so much.

请先登录，再进行评论。

类别

在 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