pandas - resampling datetime index and extending to end of the month,df.resample('M').ffill().resample('H').ffill().tail()