add a row of summary statistics in a table
14 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
alpedhuez
am 18 Jun. 2022
Kommentiert: the cyclist
am 18 Jun. 2022
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 Kommentare
Akzeptierte Antwort
Voss
am 18 Jun. 2022
t = table({'new york';'chicago'},[10;5],[17;18],'VariableNames',{' ','visitor','temperature'})
t(end+1,:) = {'' sum(t{:,'visitor'}) mean(t{:,'temperature'})}
0 Kommentare
Weitere Antworten (1)
the cyclist
am 18 Jun. 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 Kommentare
the cyclist
am 18 Jun. 2022
Oh, sorry. I misread. Looks like you got an effectively equivalent answer.
Siehe auch
Kategorien
Mehr zu Logical finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!