How to sort a cell array based on the first row?

Question

Dongyan Zhu 2021-6-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/859715-how-to-sort-a-cell-array-based-on-the-first-row

评论： Dongyan Zhu 2021-6-18

I have two rows of cell array:

Combined =
  2×3 cell array
    {'4'}    {'1'}    {'6'}
    {'1'}    {'3'}    {'4'}

Now I want to sort the first row of this 2*3 cell array from small number to large number and the second row will be sorted according to the first row, which means the second row should look like this:

    {'1'}    {'4'}    {'6'}
    {'3'}    {'1'}    {'4'}

Then I want to extract the second row as an 1*3 cell array.

Can someone help me? Many thanks.

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

请先登录，再进行评论。

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

Answer 1

the cyclist 2021-6-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/859715-how-to-sort-a-cell-array-based-on-the-first-row#answer_727830

在 MATLAB Online 中打开

Out of curiosity, is there some reason you are using a cell array rather than a numeric array to store these numeric data?

% Original data
in = {'4','1','6';'1','3','4'}
in = 2×3 cell array
    {'4'}    {'1'}    {'6'}
    {'1'}    {'3'}    {'4'}
% Sort first row, and get sorting index
[in_sorted,sorting_idx] = sort(in(1,:))
in_sorted = 1×3 cell array
    {'1'}    {'4'}    {'6'}
sorting_idx = 1×3
     2     1     3
% Extract last row, sorted according to first
out = in(2,sorting_idx)
out = 1×3 cell array
    {'3'}    {'1'}    {'4'}