How can I sort this cell Array?

8 次查看（过去 30 天）
Afsane Afsane
Afsane Afsane 2015-5-4
评论： Michael Haderlein 2015-5-5
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})?
  1 个评论
Afsane Afsane
Afsane Afsane 2015-5-4
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.

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Andrei Bobrov
Andrei Bobrov 2015-5-4
[~,ii] = sort(cat(1,ca{3}{:}));
out = cellfun(@(x)x(ii,:),ca,'un',0);
  3 个评论
显示 1更早的评论
Afsane Afsane
Afsane Afsane 2015-5-5
Thanks a lot! But I didn't understand what this function return and what are its inputs:
out = cellfun(@(x)x(ii,:),ca,'un',0);
Michael Haderlein
Michael Haderlein 2015-5-5
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.

请先登录，再进行评论。

更多回答（2 个）

dpb
dpb 2015-5-4
>> [~,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.
Afsane Afsane
Afsane Afsane 2015-5-4
编辑：Afsane Afsane 2015-5-4
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 sorted last column.
  8 个评论
显示 6更早的评论
Mohammad Abouali
Mohammad Abouali 2015-5-5
编辑：Mohammad Abouali 2015-5-5
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.
Afsane Afsane
Afsane Afsane 2015-5-5
I think I have a problem in initialize the cell array if I introduce the cell array like for example :
m={'a' 10; 'b' 12;'c' 9}
then I can use sortrows :
m1=sortrows(m,2)
but I have to change other codes :(

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Shifting and Sorting Matrices 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by