Sorting Cell Array Elements in Multiple Columns

Question

RDG 2014-7-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/140139-sorting-cell-array-elements-in-multiple-columns

评论： RDG 2014-7-3

Suppose I have a cell variable A{1} with contents as follow:

A{1}=
100  0  [6,7,8,9,10,11,12]
110  0  [6,7,8,9,10,11,12]
35  [5,14]  [6,7,8,9,10,11,12]
38  4  <1x12 double>
37  4  <1x12 double>
36  4  <1x12 double>

May I know how can I sort the elements inside the cell array based on these criteria: First, Length of elements in Column 3 (Ignoring zero) in ascending order. Then, the values in Column 2 in descending order.

The resultant should be something similar to this:

resultant{1}=
38  4   <1x12 double>
37  4  <1x12 double>
36  4  <1x12 double>
35  [5,14]  [6,7,8,9,10,11,12]
110  0  [6,7,8,9,10,11,12]
100  0  [6,7,8,9,10,11,12]

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Azzi Abdelmalek 2014-7-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/140139-sorting-cell-array-elements-in-multiple-columns#answer_143587

在 MATLAB Online 中打开

A={1  100  0  [6,7,8,9,10,11,12]
2  110  0  [6,7,8,9,10,11,12]
25  35  [5,14]  [6,7,8,9,10,11,12]
35  38  4  [6,7,8,9,10,11,12]
36  37  4  [6,7,8,9,10,11,12]
37  36  4  [6,7,8,9,10,11,12]}
c31=cellfun(@(x) any(x),A(:,3))
c32=cellfun(@(x) length(x),A(:,3))
idx3=c31.*c32
idx3(idx3==0)=inf;
[~,ii]=sortrows([cell2mat(A(:,2)) idx3],[2 -1])
out=A(ii,:)

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

RDG 2014-7-3

Thank you.

请先登录，再进行评论。

Answer 2

Cedric 2014-7-3

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/140139-sorting-cell-array-elements-in-multiple-columns#answer_143588

编辑：Cedric 2014-7-3

在 MATLAB Online 中打开

Here is one way to do it

 B = cellfun( @length, A{1}(:,3) ) ;   % Get length of el. of 3rd col of A{1}.
 B([A{1}{:,3}] == 0) = Inf ;           % Set length = Inf where 0.
 B = [[A{1}{:,2}].', B] ;              % Append col 2.
 [~,ix] = sortrows( B, [2,-1] ) ;      % Sort col 2 asc first, then col 1 desc.
 resultant{1} = A{1}(ix,:) ;           % Re-index A{1}.

Running this, you get

 >> resultant{1}
 ans = 
    [35]    [ 38]    [         4]    <1x12 double>        
    [36]    [ 37]    [         4]    <1x12 double>       
    [37]    [ 36]    [         4]    <1x12 double>       
    [25]    [ 35]    [1x2 double]    [1x7 double]
    [ 2]    [110]    [         0]    [1x7 double]
    [ 1]    [100]    [         0]    [1x7 double]