Time weighted average after every 60mins

3 次查看（过去 30 天）
Kwasi Boateng
Kwasi Boateng 2020-10-27
回答： Peter Perkins 2020-11-20
please i have a sample data as in the picture, and want to find the time weighted average after every 60 mins of the spread column
  1 个评论
Rik
Rik 2020-10-27
Sounds like a nice project. Do you have a question?
Have a read here and here. It will greatly improve your chances of getting an answer.

请先登录，再进行评论。

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

回答（2 个）

Cris LaPierre
Cris LaPierre 2020-10-27
Look into groupsummary. You'll probably want something like this. I'm assuming your data is in a table.
groupsummary(tblName,Date.time,'hour','mean',spread)
I wouldn't call this a weighted average, though. You'll need to provide more details about how you want to time-weight the average.
Peter Perkins
Peter Perkins 2020-11-20
Or put the data in a timetable and use retime(tt,'hourly','mean'). If you need weights, you can write your own aggregation function for hourly aggregation.

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by