Effacer les filtres
Effacer les filtres

Sorting dataset, which contains strings, by one column

1 vue (au cours des 30 derniers jours)
Sam
Sam le 18 Mar 2016
Commenté : Sam le 19 Mar 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!

Réponses (1)

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

Connectez-vous pour commenter.

Catégories

En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by