Can one use retime function to calculate mean and sum of the same variable?

4 vues (au cours des 30 derniers jours)
alpedhuez
alpedhuez le 15 Mai 2022
Suppose I have a timetable
Visitors
January 1 10
January 3 20
February 10 30
February 12 10
Then I want to create a table
Mean of Visitors Sum of Visitors
January 15 30
February 20 40
Can one do this with retime function? if not, how?
  9 commentaires
dpb
dpb le 15 Mai 2022
???? You mean functions, @alpedhuez?
alpedhuez
alpedhuez le 15 Mai 2022
As another example that may getting a bit too complicated.

Connectez-vous pour commenter.

Réponses (1)

Gagan Agarwal
Gagan Agarwal le 22 Sep 2023
Hi alpedhuez,
Yes, it is possible to calculate the mean and sum of the same variable using the 'retime' function.
You can refer to the following code snippet as an example to perform the calculation on your table:
% The sample data is stored in a table 'T'
T = table(["January 1"; "January 3"; "February 10"; "February 12"], [10; 20; 30; 10]);
T.Properties.VariableNames = {'Date', 'Value'};
T.Date = datetime(T.Date, 'InputFormat', 'MMMM d')
% T is converted to timetable using 'table2timetable' function.
TT = table2timetable(T);
% 'retime' function is then applied on 'TT' to calculate the mean
T1 = retime(TT, 'monthly', 'mean');
% The 'retime' function is then applied on 'TT' to calculate the sum
T2 = retime(TT, 'monthly', 'sum');
% 'T1' and 'T2' are combined into a single table called 'ans' which displays the sum and mean values
ans = join(T1,T2)
For more detailed information about the 'retime' function, you can refer to the following documentation:
I hope this helps!

Catégories

En savoir plus sur Timetables dans Help Center et File Exchange

Tags

Produits


Version

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by