Row with minimum value for each group in table

4 次查看（过去 30 天）

HE 2020-5-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/522814-row-with-minimum-value-for-each-group-in-table

编辑： HE 2020-5-5

I want to group my table by one or more variables and find the minimum value for each group. Additionally I want to return other variables corresponding to that minimum value, e.g. the complete row of that minimum value.

grpstats or findgoups+splitapply does the job for the first step, but how do I return the corresponding row or corresponding values of other Variables?

edit: This is what I came up with. It works for me, suggestions are welcome.

load hospital
dsa = hospital(:,{'Sex','Age','Weight','Smoker'});
dst = dataset2table(dsa);
t = minrowingroup(dst,{'Sex','Smoker'},{'Age','Weight'})
function out = minrowingroup(tbl,groupBy,sortBy)
    tbl.tempGroup = findgroups(tbl(:,groupBy));
    out = table();
    for i = 1: max(tbl.tempGroup)
        p = tbl(tbl.tempGroup == i,:);
        p = sortrows(p,sortBy);
        out = [out; p(1,:)];
    end
    out.tempGroup = [];
end