Avoiding for loop: Ordering and assigning order of Group data
1 次查看(过去 30 天)
显示 更早的评论
Hi
I have this data, and would like to order the loss within each group and assign the ordering index to each element.
tdata = table(["US";"US";"US";"UK";"UK";"TW";"TW";"TW";"TW"], [1;1;5;1.20000000000000;3;4;5;1;2],'VariableNames',{'name','Loss'});
name Loss
"US" 1
"US" 1
"US" 5
"UK" 1.20000000000000
"UK" 3
"TW" 4
"TW" 5
"TW" 1
"TW" 2
[ uniqGrp,~,JGrp]= unique( tdata( :,{'name'}));
tAll = table;
for runi= 1: height( uniqGrp)
tt = tdata( JGrp== runi, :);
tt = sortrows( tt, {'Loss'});
tt.idx = [1:height(tt)]';
tAll = [tAll; tt];
end
so final data tAll looks like this
name Loss idx
"TW" 1 1
"TW" 2 2
"TW" 4 3
"TW" 5 4
"UK" 1.20000000000000 1
"UK" 3 2
"US" 1 1
"US" 1 2
"US" 5 3
0 个评论
采纳的回答
Matt J
2023-8-23
编辑:Matt J
2023-8-23
tdata = table(["US";"US";"US";"UK";"UK";"TW";"TW";"TW";"TW"], [1;1;5;1.20000000000000;3;4;5;1;2],'VariableNames',{'name','Loss'});
out=varfun(@gfunc,tdata,'Group','name','Input','Loss');
out=table(out.name,out{:,3}(:,1), out{:,3}(:,2), 'Var',["name","Loss","idx"])
function out=gfunc(y)
x=sort(y);
out=[x,(1:numel(x))'];
end
更多回答(0 个)
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!