Time weighted average after every 60mins
3 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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
Risposte (2)
Cris LaPierre
il 27 Ott 2020
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.
0 Commenti
Peter Perkins
il 20 Nov 2020
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.
0 Commenti
Vedere anche
Categorie
Scopri di più su Database Toolbox in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!