Sort cell according to one column of the cell

164 Ansichten (letzte 30 Tage)
Maria
Maria am 13 Aug. 2014
Beantwortet: Andrei Bobrov am 13 Aug. 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,:);

Akzeptierte Antwort

Andrei Bobrov
Andrei Bobrov am 13 Aug. 2014
out = sortrows(A,[3,1]);

Weitere Antworten (0)

Kategorien

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

Tags

Produkte

Community Treasure Hunt

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

Start Hunting!

Translated by