Resample datetime to minute resolution

14 次查看（过去 30 天）

显示更早的评论

Alex 2019-8-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/476451-resample-datetime-to-minute-resolution

评论： Adam Danz 2019-8-20

采纳的回答： Andrei Bobrov

Hi community!

Thanks in advance for the help and suggestions I always receive. Now I jumo to my query!

So, I have a dataset as shown in the attached photo. I have a Start Time (1st column) and End Time (2nd column) of filling up of Gas Pump in Volume (3rd column). I want to resample every 1 minute based on Start Time and End Time. For the rest hours of the day, I want 0 values. At the end, I should have 1440 (24 x 60) values. I tried the "retime" function but was unsuccessful. Could anyone help me out?

Thanks again

2 个评论
显示无隐藏无

Walter Roberson 2019-8-16

Do you have a dataset() array from Statistics Toolbox? Do you have a table() from basic MATLAB? Do you have a timetable() ?

Alex 2019-8-16

example.mat

Yes Walter. I have attached the data in table format.

请先登录，再进行评论。

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

采纳的回答

Andrei Bobrov 2019-8-16

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/476451-resample-datetime-to-minute-resolution#answer_387937

编辑：Andrei Bobrov 2019-8-16

在 MATLAB Online 中打开

T = fuel1(:,{'Start','Volume'});
T.Properties.VariableNames={'time','vol'};
T1=table;
T1.time = fuel1.End;
T1.vol = zeros(size(fuel1,1),1);
T = table2timetable(sortrows([T;T1]));
Tout = retime(T,'minutely','previous');