Sorting dataset, which contains strings, by one column

Sam
2016 3 18
1 个回答
更新时间：2016 3 19
1 次查看（30 天）

0 个投票

Hello,
I have a matrix of 1198x17. The first column is a column containing only strings. The first row contains 1 stringcell in cell 17, the rest of the first row are numbers. In cell A1 is a NaNvalue. All the other cells contain numbers. I need to sort this dataset by column #17 in such way that all the rows stay the same. How do I do this?
Thanks!

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

回答（1 个）

Walter Roberson
Walter Roberson 2016-3-19

0 个投票

sortrows(A, 17)

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

Sam
Sam 2016-3-19
The dataset is an excelfile. So if I use the code for xlsread, this isn't possible.
[num,txt,raw] = xlsread('dataset');
num contains only the number, txt only the stringcells, and raw contains everything. If I than use 'sort' or 'sortrows' for 'raw' Matlab gives an error...

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Logical 的更多信息

标签

提问:

Sam
Sam
2016-3-18

评论：

Sam
Sam
2016-3-19

Community Treasure Hunt

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

Start Hunting!

Translated by