Sorting dataset, which contains strings, by one column

1 view (last 30 days)
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!

Answers (1)

Walter Roberson
Walter Roberson on 19 Mar 2016
sortrows(A, 17)
  1 Comment
Sam
Sam on 19 Mar 2016
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...

Sign in to comment.

Tags

Community Treasure Hunt

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

Start Hunting!