Sort cell according to one column of the cell

72 vues (au cours des 30 derniers jours)
Maria
Maria le 13 Août 2014
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,:);

Réponse acceptée

Andrei Bobrov
Andrei Bobrov le 13 Août 2014
out = sortrows(A,[3,1]);

Plus de réponses (0)

Catégories

En savoir plus sur Shifting and Sorting Matrices dans Help Center et File Exchange

Tags

Produits

Community Treasure Hunt

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

Start Hunting!

Translated by