清空筛选条件
清空筛选条件

Timetable with 15 min averages

3 次查看（过去 30 天）
Anna Go
Anna Go 2019-7-12
评论： Anna Go 2019-7-13
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!
  1 个评论
Walter Roberson
Walter Roberson 2019-7-12
I would suspect that you have duration values rather than datetime values.

请先登录，再进行评论。

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

采纳的回答

Jon
Jon 2019-7-12
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))

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Time Series Events 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by