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

[Walter Roberson]

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

[Alex]

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

Answer 1

[Andrei Bobrov]

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');

[Alex]

Thanks, Andrei! It works like a charm.

[Alex]

Dear Andrei,

How to proceed if we want some other sampling time, say 15minutes?

I tried to initalize 15minutes time in place of 'minutely' but I realized it is not correct.

Thanks

[Alex]

I followed this thread as well: https://www.mathworks.com/matlabcentral/answers/371018-how-to-retime-time-series-data-every-15-minutes-or-if-it-is-not-possible-to-filter-minutely-data-t

But, the result looks suspicios to me.

[Adam Danz]

Use the 'dt' property

https://www.mathworks.com/help/matlab/ref/timetable.retime.html#d117e1187153

 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.

https://www.mathworks.com/help/matlab/ref/timetable.retime.html#bvdhiwr-method

[Alex]

Great! I just figured out that. Thanks again Adam!

[Adam Danz]

retime() is quite powerful. I have to reference the documentation frequently when I use it.