How can I sort a cell array according to one column's order?

11 次查看(过去 30 天)
Hi, I have a cell array of (50, 2), each cell in the first column contains a 4x960 matrix but the cells in the second column are 1x1 numbers. Each cell in the second column shows the rank for the matrix in the same row of the cell array. For example cell(1,1) is a 4x960 matrix and it's rank is in cell(1,2). I want to sort this cell array according to the rank(second) column, meaning that if a matrix (in the first column) has the highest rank(in the second column) and needs to be moved to the last row(descending order), it's matrix in the first column should move with it to the last row, too. Would you please help me?

回答(1 个)

Alexandra Harkai
Alexandra Harkai 2016-10-31
There may be a conflict in what you define to be of 'descending order':
"if a matrix (in the first column) has the highest rank(in the second column) and needs to be moved to the last row(descending order), it's matrix in the first column should move with it to the last row, too"
This example goes with the "first row will have the smallest rank" way:
A; % this is the input cell array
[ranks_ordered, idx] = sort(cell2mat(A(:,2)));
B = A(idx,:);
sort returns the sorting indices as the second output argument, which is then used to re-sort the original cell array.
  4 个评论

请先登录,再进行评论。

类别

Help CenterFile Exchange 中查找有关 Shifting and Sorting Matrices 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by