Count smaller than 15 cells in the table coulumns

1 view (last 30 days)
BN on 16 Jan 2020
Edited: Andrei Bobrov on 16 Jan 2020
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

Edited: adeq123 on 16 Jan 2020
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
BN on 16 Jan 2020
Thank You Very Much

Andrei Bobrov on 16 Jan 2020
Edited: Andrei Bobrov on 16 Jan 2020
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

Categories

Find more on Creating and Concatenating Matrices in Help Center and File Exchange

R2018b

Community Treasure Hunt

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

Start Hunting!