How can I sort this cell Array?

4 次查看（过去 30 天）

显示更早的评论

Afsane Afsane 2015-5-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/215031-how-can-i-sort-this-cell-array

评论： Michael Haderlein 2015-5-5

采纳的回答： Andrei Bobrov

在 MATLAB Online 中打开

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

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 2015-5-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/215031-how-can-i-sort-this-cell-array#answer_177761

在 MATLAB Online 中打开

[~,ii] = sort(cat(1,ca{3}{:}));
out = cellfun(@(x)x(ii,:),ca,'un',0);

3 个评论
显示 1更早的评论隐藏 1更早的评论

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 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 2015-5-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/215031-how-can-i-sort-this-cell-array#answer_177760

在 MATLAB Online 中打开

>> [~,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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Afsane Afsane 2015-5-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/215031-how-can-i-sort-this-cell-array#answer_177762

编辑：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更早的评论隐藏 6更早的评论

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 2015-5-5