Sort cell according to one column of the cell

174 ビュー (過去 30 日間)
Maria
Maria 2014 年 8 月 13 日
回答済み: Andrei Bobrov 2014 年 8 月 13 日
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,:);

採用された回答

Andrei Bobrov
Andrei Bobrov 2014 年 8 月 13 日
out = sortrows(A,[3,1]);

その他の回答 (0 件)

カテゴリ

Help Center および File ExchangeShifting and Sorting Matrices についてさらに検索

タグ

製品

Community Treasure Hunt

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

Start Hunting!

Translated by