Timetable with 15 min averages

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!

[Walter Roberson]

I would suspect that you have duration values rather than datetime values.

Answer 1

[Jon]

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

[Anna Go]

Thanks! works perfectly