Solved

Fill gaps in time series data?

Forum|Forum|1 year ago
May 13, 2024
3 replies
87 views

+5

jacklonsdale
Contributor

Hi all,

I have a 15 minute timestep data which has random missing values (expected). I’ve managed to track where the data has gaps, but in order to calculate a consistent rolling 24 average of the value I need to fill these missing gaps with a timestep but null value (so i can calculate an average from the preceding X values)

Does anyone have any suggestions on how to fill these data gaps automatically? Or better still calculate a 24 hour rolling average using specific timesteps rather than just number of rows?

Thanks

Best answer by geomancer

You can create all the timestamps you should have, and merge these with your actual data stream to get a continuous series of timestamps.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.