Resample datetime to minute resolution
显示 更早的评论
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
采纳的回答
Andrei Bobrov
2019-8-16
编辑：Andrei Bobrov
2019-8-16
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');
6 个评论
Alex
2019-8-17
Alex
2019-8-20
Adam Danz
2019-8-20
Use the 'dt' property
Tout = retime(T,'regular','previous','TimeStep',minutes(15))
You might want to think about the various "methods" and which would be best for your needs.
Alex
2019-8-20
Adam Danz
2019-8-20
retime() is quite powerful. I have to reference the documentation frequently when I use it.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Data Type Conversion 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
