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

7 views (last 30 days)
Dongyan Zhu
Dongyan Zhu on 18 Jun 2021
Commented: Dongyan Zhu on 18 Jun 2021
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.

Accepted Answer

the cyclist
the cyclist on 18 Jun 2021
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'}
  1 Comment
Dongyan Zhu
Dongyan Zhu on 18 Jun 2021
Thank you! I just want to directly use the cell array for the data transfer later in the task.

Sign in to comment.

More Answers (0)

Products


Release

R2020a

Community Treasure Hunt

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

Start Hunting!