add a row of summary statistics in a table
14 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Suppose I have a table in Matlab:
Then I want to add a summary statistics (sum for the first col and average for the second col)
Then how shall I proceed?
0 commentaires
Réponse acceptée
Voss
le 18 Juin 2022
t = table({'new york';'chicago'},[10;5],[17;18],'VariableNames',{' ','visitor','temperature'})
t(end+1,:) = {'' sum(t{:,'visitor'}) mean(t{:,'temperature'})}
0 commentaires
Plus de réponses (1)
the cyclist
le 18 Juin 2022
Here is one way:
% The table
T = table([10;5],[17;18],'VariableNames',{'visitor','temperature'},'RowNames',{'New York','Chicago'});
% Numeric variables for the mean
vars = {'visitor','temperature'};
% Calculate the mean
varsMean = mean(T{:,vars});
% Append mean to table, and change the RowNames property of that row
T{end+1,vars} = varsMean;
T.Properties.RowNames{end} = 'mean';
% Display
T
2 commentaires
the cyclist
le 18 Juin 2022
Oh, sorry. I misread. Looks like you got an effectively equivalent answer.
Voir également
Catégories
En savoir plus sur Logical dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!