MATLAB: Timetable with 15 min averages

averagestime seriestimetable

Hi everyone,
I have a table with 1min data over a period of 24h. I attached the csv document I am using.
I want to create 15 min averages. However I don't know how to do the 15 min averages.
This is the code I am using:
house_load = readtable('Load_profile_1.csv');
house_load = table2timetable(house_load);
newTimes = [datetime('00:00:00','Format','HH:mm:ss'):minutes(15):datetime('23:59:00','Format','HH:mm:ss')];
avg_house_load = retime(house_load,newTimes,'mean')
I get an error message in line 3.
Any idea how I could get 15 min averages for my data.
Thanks!

Best Answer

Try this for your fourth line (and skip your third line assigning new_times, as it is not needed with this approach)
house_load = retime(house_load,'regular','mean','TimeStep',minutes(15))
Related Question