How to sort a cell array with respect to another cell array?

Question

Liam 2023-6-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1988878-how-to-sort-a-cell-array-with-respect-to-another-cell-array

评论： Liam 2023-6-27

采纳的回答： Dyuman Joshi

在 MATLAB Online 中打开

Hello:

If I have cell array A:

cellA = {'A', 'B', 'C', 'D'; 1, 2, 3, 4; 5, 6, 7, 8; 9, 1, 2, 3}
cellA = 4×4 cell array
    {'A'}    {'B'}    {'C'}    {'D'}
    {[1]}    {[2]}    {[3]}    {[4]}
    {[5]}    {[6]}    {[7]}    {[8]}
    {[9]}    {[1]}    {[2]}    {[3]}

and cell array B:

cellB = {'C', 'A', 'D'; 1, 2, 3; 4, 5, 6; 7, 8, 9}
cellB = 4×3 cell array
    {'C'}    {'A'}    {'D'}
    {[1]}    {[2]}    {[3]}
    {[4]}    {[5]}    {[6]}
    {[7]}    {[8]}    {[9]}

Is there a way to sort cellB with respect to cellA (specifically the first row, but with the capability to look to other rows to tiebreak)? Such that the final cellB array looks something like this, including the null spaces:

cellBFinal = {'A' '' 'C' 'D'; 2 [] 1 3; 5 [] 4 6; 8 [] 7 9}
cellBFinal = 4×4 cell array
    {'A'}    {0×0 char  }    {'C'}    {'D'}
    {[2]}    {0×0 double}    {[1]}    {[3]}
    {[5]}    {0×0 double}    {[4]}    {[6]}
    {[8]}    {0×0 double}    {[7]}    {[9]}

Thank you!

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

请先登录，再进行评论。

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

Answer 1

Dyuman Joshi 2023-6-27

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1988878-how-to-sort-a-cell-array-with-respect-to-another-cell-array#answer_1263693

在 MATLAB Online 中打开

Here's one approach -

%Note that this approaches requires the 1st row of cellA to be sorted
cellA = {'A', 'B', 'C', 'D'; 1, 2, 3, 4; 5, 6, 7, 8; 9, 1, 2, 3};
cellB = {'C', 'A', 'D'; 1, 2, 3; 4, 5, 6; 7, 8, 9};
%positions of elements of row 1 from cellB which are common to elements of row 1 from cellA 
[~,y]=ismember(cellA(1,:),cellB(1,:))
y = 1×4
     2     0     1     3
z = any(y==0);
if z
    %Concatenate empty spaces according to the class of elements with cellB
    %only there is a missing common element (in this case 'B')
    cellB = [cellfun(@(x) x([]), cellB(:,1), 'uni', 0) cellB];
end
%Final output
cellC = cellB(:,y+z)
cellC = 4×4 cell array
    {'A'}    {0×0 char  }    {'C'}    {'D'}
    {[2]}    {0×0 double}    {[1]}    {[3]}
    {[5]}    {0×0 double}    {[4]}    {[6]}
    {[8]}    {0×0 double}    {[7]}    {[9]}

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

Jon 2023-6-27

I see, thanks for the clarification.

Liam 2023-6-27

Thank you! This method works great.

请先登录，再进行评论。

Answer 2

Jon 2023-6-27

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1988878-how-to-sort-a-cell-array-with-respect-to-another-cell-array#answer_1263688

在 MATLAB Online 中打开

cellA = {'A', 'B', 'C', 'D'; 1, 2, 3, 4; 5, 6, 7, 8; 9, 1, 2, 3}
cellA = 4×4 cell array
    {'A'}    {'B'}    {'C'}    {'D'}
    {[1]}    {[2]}    {[3]}    {[4]}
    {[5]}    {[6]}    {[7]}    {[8]}
    {[9]}    {[1]}    {[2]}    {[3]}
cellB = {'C', 'A', 'D'; 1, 2, 3; 4, 5, 6; 7, 8, 9}
cellB = 4×3 cell array
    {'C'}    {'A'}    {'D'}
    {[1]}    {[2]}    {[3]}
    {[4]}    {[5]}    {[6]}
    {[7]}    {[8]}    {[9]}
[lia,lib] = ismember(cellA(1,:),cellB(1,:))
lia = 1×4 logical array
   1   0   1   1
lib = 1×4
     2     0     1     3
cellBFinal = cell(size(cellA,2),size(cellB,1))
cellBFinal = 4×4 cell array
    {0×0 double}    {0×0 double}    {0×0 double}    {0×0 double}
    {0×0 double}    {0×0 double}    {0×0 double}    {0×0 double}
    {0×0 double}    {0×0 double}    {0×0 double}    {0×0 double}
    {0×0 double}    {0×0 double}    {0×0 double}    {0×0 double}
cellBFinal(:,lia) = cellB(:,lib(lia))
cellBFinal = 4×4 cell array
    {'A'}    {0×0 double}    {'C'}    {'D'}
    {[2]}    {0×0 double}    {[1]}    {[3]}
    {[5]}    {0×0 double}    {[4]}    {[6]}
    {[8]}    {0×0 double}    {[7]}    {[9]}

2 个评论
显示无隐藏无

Jon 2023-6-27

@Liam if it is important to you to have all the elements of the first row as char, then @Dyuman Joshi's somewhat more elaborate construction of the empty cell array will be needed. Otherwise can just initialize with all elements as empty doubles.

Liam 2023-6-27

Yes, the first element does need everything to be characters (I suppose it could be converted quite easily in a later step so your method also works great).

请先登录，再进行评论。