Sorting cells with headers... how to start sorting at row 2

1 visualización (últimos 30 días)
John
John el 28 de Oct. de 2014
Comentada: John el 28 de Oct. de 2014
I know this has to be simple, but I can't for the life of me figure it out.
I have a five Nx6 cell arrays that I'm trying to sort using the sortrows function. The cell arrays have a header row (row 1). It will sort the data, but it treats the header row the same as the other data and sorts it accordingly, moving it from its row 1 position to somewhere else.
Is there a way to use the sortrows function and tell it to sort from row 2 to the end?
For example, cell A is an Nx6 array, and I want to sort it by column 6. I'm using
A = sortrows(A,6);
I've seen something along the lines of
A = sortrows(A,A(2:end,6))
but that's not working.
Any help is appreciated.

Respuesta aceptada

Michael Haderlein
Michael Haderlein el 28 de Oct. de 2014
You have mixed up a bit in your suggestion of the solution:
sA=[A(1,:);sortrows(A(2:end,:),2)];

Más respuestas (0)

Categorías

Más información sobre Shifting and Sorting Matrices en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by