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

4 次查看（过去 30 天）

alpedhuez 2022-5-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1719710-can-one-use-retime-function-to-calculate-mean-and-sum-of-the-same-variable

回答： Gagan Agarwal 2023-9-22

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 个评论
显示 7更早的评论隐藏 7更早的评论

dpb 2022-5-15

???? You mean functions, @alpedhuez?

alpedhuez 2022-5-15

As another example that may getting a bit too complicated.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Gagan Agarwal 2023-9-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1719710-can-one-use-retime-function-to-calculate-mean-and-sum-of-the-same-variable#answer_1315612

在 MATLAB Online 中打开

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) 