I shouldn't convert the cell array to array. Is there any function to sort the array based on last column directly? or at least sort the first column (string column) based on last column.
How can I sort this cell Array?
6 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Afsane Afsane
il 4 Mag 2015
Commentato: Michael Haderlein
il 5 Mag 2015
Hello
I have a cell arraye like this:
ca{1,1}={'x' ;'y'; 'z'};
ca{1,2}=[1 1 9 3;...
5 1 1 1;...
5 7 5 9];
ca{1,3}={13; 14 ; 10};
How can I sort this cell Array based on last column ( ca{1,3})?
Risposta accettata
Andrei Bobrov
il 4 Mag 2015
[~,ii] = sort(cat(1,ca{3}{:}));
out = cellfun(@(x)x(ii,:),ca,'un',0);
3 Commenti
Michael Haderlein
il 5 Mag 2015
It applies a function on each element of a cell. The cell is ca and the function is @(x)x(ii,:). x is the cell element here. So in the end, it just applies the sorting array ii on each element of the cell. The 'un',0 is an additional parameter which is required whenever the output is a cell and not a numerical array. Just play with cellfun, you'll understand it easily.
Più risposte (2)
dpb
il 4 Mag 2015
>> [~,ix]=sort(cell2mat(ca{1,3}));
>> ca{1,2}=ca{1,2}(ix,:);
>> ca{1,2}
ans =
5 1 1 1
5 7 5 9
1 1 9 3
>>
Having the last cell as an array of three elements instead of a 3-vector makes it tougher--otherwise could do away w/ the cell2mat and just use the curlies to address the cell for sorting.
0 Commenti
Afsane Afsane
il 4 Mag 2015
Modificato: Afsane Afsane
il 4 Mag 2015
8 Commenti
Mohammad Abouali
il 5 Mag 2015
Modificato: Mohammad Abouali
il 5 Mag 2015
cat(1,ca{3}{:}) in Andrei Bobrov's answer is still converting a cell array to regular array then sorts it. That's not any different than dpb's first answer using cell2mat.
The problem is that she wants to do it without any conversion to other data format.
Vedere anche
Categorie
Scopri di più su Shifting and Sorting Matrices in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!