假设以下数据框:
values
2019-01-01 00:01:56 0.149511
2019-01-01 00:03:54 0.608400
2019-01-01 00:05:48 1.345600
2019-01-01 00:08:54 3.168400
2019-01-01 00:11:59 5.744011
2019-01-01 00:14:30 8.410000
2019-01-01 00:17:39 12.460900
2019-01-01 00:20:04 16.106844
2019-01-01 00:23:02 21.221378
2019-01-01 00:25:14 25.468844
2019-01-01 00:28:33 32.604100
2019-01-01 00:30:17 36.683211
2019-01-01 00:33:14 44.178178
2019-01-01 00:35:26 50.220844
2019-01-01 00:38:10 58.267778
2019-01-01 00:40:23 65.232544
2019-01-01 00:42:22 71.797378
2019-01-01 00:44:30 79.210000
2019-01-01 00:46:14 85.500844
2019-01-01 00:48:23 93.637878
如您所见,索引是随机时间(相隔 100 到 200 秒(。我想得到一个具有插值的数据框,在特定频率下(例如每 5 分钟一次,索引在[00:00:00, 00:05:00, 00:10:00 ... 00:55:00]
上运行等(,当然还有用某种特定方法(立方体、线性等(插值的值。
data.resample('1s').asfreq().interpolate().resample('5min').last()