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

1 visualización (últimos 30 días)
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 comentarios
alpedhuez
alpedhuez el 15 de Mayo de 2022
As another example that may getting a bit too complicated.

Iniciar sesión para comentar.

Respuestas (1)

Gagan Agarwal
Gagan Agarwal el 22 de Sept. de 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!

Categorías

Más información sobre Data Preprocessing en Help Center y File Exchange.

Etiquetas

Productos


Versión

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by