我有一些不规则的时间戳数据,看起来像:
Oil Pres. Out ppm Ratio In Out Inlet psi Bag psi
Date
2013-12-10 19:01:00 56 0 0 455 462 2.26 0.44
2013-12-10 20:00:00 55 0 0 450 456 10.91 0.73
2013-12-10 20:33:00 55 0 0 443 452 9.24 0.54
2013-12-10 22:00:00 54 0 0 440 449 8.16 0.62
2013-12-10 22:31:00 54 0 0 436 445 10.29 0.49
我如何在两个日期之间对齐数据(例如:2013-12-10 18:00:00和2013-12-11 00:00:00,间隔20分钟,显示如下:
Oil Pres. Out ppm Ratio In Out Inlet psi Bag psi
Date
2013-12-10 18:00:00 NaN...
2013-12-10 18:20:00
2013-12-10 18:40:00
2013-12-10 19:00:00 56 0 0 455 462 2.26 0.44
2013-12-10 19:20:00
2013-12-10 19:40:00
2013-12-10 20:00:00 55 0 0 450 456 10.91 0.73
2013-12-10 20:20:00
2013-12-10 20:40:00 55 0 0 443 452 9.24 0.54
2013-12-10 21:00:00
2013-12-10 21:20:00
2013-12-10 21:40:00
2013-12-10 22:00:00 54 0 0 440 449 8.16 0.62
2013-12-10 22:20:00
2013-12-10 22:40:00 54 0 0 436 445 10.29 0.49
2013-12-10 23:00:00
2013-12-10 23:20:00
2013-12-10 23:40:00
2013-12-11 00:00:00
可能:
df.resample( '20T', how='mean' )
或者,你可以这样做:
idx = pd.date_range( start='2013-12-10 18:00:00',
end='2013-12-11 00:00:00',
freq='20T' )
df.reindex( idx, method='ffill', limit=1 )