Count smaller than 15 cells in the table coulumns
1 view (last 30 days)
Show older comments
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 Comments
Accepted Answer
adeq123
on 16 Jan 2020
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
More Answers (1)
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
0 Comments
See Also
Categories
Find more on Creating and Concatenating Matrices in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!