Sort cell according to one column of the cell

165 visualizzazioni (ultimi 30 giorni)
I have a cell type variable A with 500000 rows and 3 columns. See example below:
C1 C2 C3 C4
A={1994 'AACE' 2071 2
1998 'DFE' 7843 4
1999 'HC' 2071 4
1995 'JOP' 7843 4
1995 'IAC' 2071 2
I would like to sort this variable first by the C3 and then by C1. So I would have:
C1 C2 C3 C4
A={1994 'AACE' 2071 2
1995 'IAC' 2071 2
1999 'HC' 2071 4
1995 'JOP' 7843 4
1998 'DFE' 7843 4
I tried the follwoing code, but I am not being successful:
[~,i1]=sort(A(:,3)); %sort by column 3 A=A(i1,:);
[~,i1]=sort(A(:,1)); %sort by column 1 next A=A(i1,:);

Risposta accettata

Andrei Bobrov
Andrei Bobrov il 13 Ago 2014
out = sortrows(A,[3,1]);

Più risposte (0)

Categorie

Scopri di più su Shifting and Sorting Matrices in Help Center e File Exchange

Tag

Prodotti

Community Treasure Hunt

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

Start Hunting!

Translated by