Count smaller than 15 cells in the table coulumns

1 次查看（过去 30 天）
BN
BN 2020-1-16
编辑： Andrei Bobrov 2020-1-16
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:
Capture.JPG
I attached my table (myresults.mat) for you.
Thank you and Best Regards

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

采纳的回答

adeq123
adeq123 2020-1-16
编辑：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 个）

Andrei Bobrov
Andrei Bobrov 2020-1-16
编辑：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

类别

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

标签

产品


版本

R2018b

Community Treasure Hunt

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

Start Hunting!

Translated by