Count smaller than 15 cells in the table coulumns

Question

BN 2020-1-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/500541-count-smaller-than-15-cells-in-the-table-coulumns

编辑： Andrei Bobrov 2020-1-16

myresults.mat

I have a 125*5 table, I want to know how many cells are smaller than 15 in each column of tmax_m, tmin_m, rrr24, tm_m separately.

something like this:

I attached my table (myresults.mat) for you.

Thank you and Best Regards

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

请先登录，再进行评论。

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

Answer 1

adeq123 2020-1-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/500541-count-smaller-than-15-cells-in-the-table-coulumns#answer_410380

编辑：adeq123 2020-1-16

The easiest way would be to just scan the table with for/while loop and increment the number of cells when the if condition is match.

tmax_i = 0;
tmin_i = 0;
rrr24_i = 0;
tm_m = 0;
for i = 1:height(results_excel)
    
    if(results_excel.tmax_m(i) < 15)
        tmax_i = tmax_i + 1;
    end
    
      if(results_excel.tmin_m(i) < 15)
        tmin_i = tmin_i + 1;
      end
    
        if(results_excel.rrr24(i) < 15)
        rrr24_i = rrr24_i + 1;
        end
    
          if(results_excel.tm_m(i) < 15)
        tm_m = tm_m + 1;
    end
end
tmax_i
tmin_i
rrr24_i
tm_m

Output:

tmax_i = 110

tmin_i = 107

rrr24_i = 94

tm_m = 78

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

BN 2020-1-16

Thank You Very Much

请先登录，再进行评论。

Answer 2

Andrei Bobrov 2020-1-16

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/500541-count-smaller-than-15-cells-in-the-table-coulumns#answer_410386

编辑：Andrei Bobrov 2020-1-16

T = varfun(@funir,results_excel,'I',2:5);
T.Properties.VariableNames = results_excel.Properties.VariableNames(2:end);
T.stationNames = {'Number of smaller than 15 cells'};
out = [results_excel;T(:,[end,1:end-1])];
function out = funir(x)
    out = sum(x < 15);
end