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 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Afsane Afsane
le 4 Mai 2015
Commenté : Michael Haderlein
le 5 Mai 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})?
Réponse acceptée
Andrei Bobrov
le 4 Mai 2015
[~,ii] = sort(cat(1,ca{3}{:}));
out = cellfun(@(x)x(ii,:),ca,'un',0);
3 commentaires
Michael Haderlein
le 5 Mai 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.
Plus de réponses (2)
dpb
le 4 Mai 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 commentaires
Afsane Afsane
le 4 Mai 2015
Modifié(e) : Afsane Afsane
le 4 Mai 2015
8 commentaires
Mohammad Abouali
le 5 Mai 2015
Modifié(e) : Mohammad Abouali
le 5 Mai 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.
Voir également
Catégories
En savoir plus sur Shifting and Sorting Matrices dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!