Use Pandas resample and asfreq() to fill in missing data

[blaylockbk]

Mesonest station data is often reported at regular intervals. For example, this buoy reports every 10 minutes:

from synoptic.services import stations_timeseries

s = stations_timeseries(
    start='2017-10-03 9:00',
    end='2017-10-04',
    stid='46053',
    vars='wind_speed'
)

But if we plot it, there is obviously a period of time with missing data...

s.plot()

You can use Panda's resampling method to fill in the missing data by resampling the DataFrame to 10-minute interval and resample asfreq() so the data matches the resample frequency

s = s.resample('10min').asfreq()
s.plot()