Sort cell values greater and smaller than the threshold

Question

NA 2020-4-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/516928-sort-cell-values-greater-and-smaller-than-the-threshold

评论： Image Analyst 2020-4-11

I have

C={[7],[4],[1],[2],[1],[3]};
A = [1 2 4 9; 6 9 9 13; 9 14 9 15; 11 14 11 14; 13 14 15 18; 11 16 11 16];
thresh = 3;

I want to sort the cell array according to

1-find values bigger than 3

{[7],[4],[3]}

2- sort it from smallest (3) to largest

{[3],[4],[7]}

3- add the remaining value of C to C_new (in largest to smallest order)

C_new ={[3],[4],[7],[2],[1],[1]}

4- change the order of A according to C_new

[7] in C is correspond to [1 2 4 9] in A

result should be

C_new ={[3],[4],[7],[2],[1],[1]}
A_new = [ 11 16 11 16;
           6  9  9 13;
           1  2  4  9;
           11 14 11 14;
           9  14  9 15;
           13 14 15 18]

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

请先登录，再进行评论。

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

Answer 1

the cyclist 2020-4-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/516928-sort-cell-values-greater-and-smaller-than-the-threshold#answer_425248

编辑：the cyclist 2020-4-10

A little awkward, but it works.

The algorithm is based on the fact that you want all elements sorted by their distance from the threshold value, but with all the above-threshold values coming before the below-threshold values.

% Original data
C={[7],[4],[1],[2],[1],[3]};
A = [1 2 4 9; 6 9 9 13; 9 14 9 15; 11 14 11 14; 13 14 15 18; 11 16 11 16];
thresh = 3;
% Convert C to numeric
dblC = cell2mat(C);
% Find the maximum distance that any element is from threshold.
% (This will become a "penalty" to below-threshold values,
% ensuring they are "further" from the threshold than any
% above-threshold value
maxdist = max(abs(dblC-thresh));
% Define a metric that is distance from threshold,
% but where below-threshold values are penalized
metric = abs(dblC-thresh) + maxdist.*(dblC<thresh);
% Sort the values according to that metric
[~,sortingIndex] = sort(metric);
C_new = C(sortingIndex);
A_new = A(sortingIndex,:);

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

Image Analyst 2020-4-11

Alright, how did you get a copy of the Mind Reading Toolbox.

请先登录，再进行评论。

Answer 2

Image Analyst 2020-4-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/516928-sort-cell-values-greater-and-smaller-than-the-threshold#answer_425243

Clear as mud. I have no idea what A is used for, what step 4 means, and how A_new is computed, but this will get you through step 3:

C={[7],[4],[1],[2],[1],[3]}
dblC = cell2mat(C) % Convert to double for simplicity in sorting.
A = [1 2 4 9; 6 9 9 13; 9 14 9 15; 11 14 11 14; 13 14 15 18; 11 16 11 16]
thresh = 3;
logicalIndexes = dblC >= thresh
part1 = sort(dblC(logicalIndexes), 'ascend')
part2 = sort(dblC(~logicalIndexes), 'descend')
cMat = [part1, part2]
% Put into cell for some weird reason
for k = 1 : length(cMat)
	C_new{k} = cMat(k);
end