Sorting dataset, which contains strings, by one column

3 Ansichten (letzte 30 Tage)
Sam
Sam am 18 Mär. 2016
Kommentiert: Sam am 19 Mär. 2016
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!

Antworten (1)

Walter Roberson
Walter Roberson am 19 Mär. 2016
sortrows(A, 17)
  1 Kommentar
Sam
Sam am 19 Mär. 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...

Melden Sie sich an, um zu kommentieren.

Kategorien

Mehr zu Shifting and Sorting Matrices finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by