ranking a cell array

4 次查看（过去 30 天）
Richard
Richard 2012-3-1
Take the following example:
clear all
Name1 = {'Data1','Data2','Data3','Data4'};
Data = {6.2,6,3.2,8};
CombnsName = nchoosek(Name1,2);
CombnsData = nchoosek(Data,2);
for i = 1:length(CombnsData);
multiplied{i} = CombnsData{i,1}.*CombnsData{i,2};
end
multiplied = multiplied';
Final = [CombnsName, multiplied];
Rankd = sort(cell2mat(multiplied));
Here, Final represents the values gained by multiplying every possible combination of 'Name1'. Now, I'm trying to find a way of changing the order of 'Final' to correspond to the ranking order defined by 'Rankd'. For example the first 'line' of Final should read 'Data2 'Data3' 19.2; and the last 'line' should read 'Data1' Data4' 49.6.
Is there a method for doing this?

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

采纳的回答

Andrei Bobrov
Andrei Bobrov 2012-3-1
Cresult = cellfun(@times,CombnsData(:,1),CombnsData(:,2))
[C,id] = sort(Cresult);
out = [CombnsName(id,:) num2cell(C)]
  2 个评论
Richard
Richard 2012-3-1
also just came across the command sortrows which works
Andrei Bobrov
Andrei Bobrov 2012-3-1
yes
out = sortrows([CombnsName cellfun(@times,CombnsData(:,1),CombnsData(:,2),'un',0)],3)

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Structures 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by