在現有的數據幀中;2019-12-02 | 1.000000 2019-12-04 | 1.0201002019-12-05 | 1.0303012019-12-06 | 1.0406042019-12-09 | 1.0510102019-12-10 | 1.061520我想添加一個基于現有DF或TS的新列，具有不匹配的索引;2019-12-04 00:00:00 | A2019-12-05 15:40:00 | B2019-12-07 00:30:00 | C2019-12-10 15:00:00 | D結果;2019-12-02 | 1.000000 NaN2019-12-04 | 1.020100 A2019-12-05 | 1.030301 B2019-12-06 | 1.040604 C2019-12-09 | 1.051010 NaN2019-12-10 | 1.061520 D現有數據幀中的間隔也可以小于 24 小時。
1 回答
慕的地8271018
TA貢獻1796條經驗 獲得超4個贊
使用merge_asof：
df = pd.merge_asof(df1,
df2,
left_index=True,
right_index=True,
tolerance=pd.Timedelta(24, 'H'),
direction='forward')
print (df)
A B
2019-12-02 1.000000 NaN
2019-12-04 1.020100 A
2019-12-05 1.030301 B
2019-12-06 1.040604 NaN
2019-12-09 1.051010 NaN
2019-12-10 1.061520 D
df = pd.merge_asof(df1,
df2,
left_index=True,
right_index=True,
tolerance=pd.Timedelta(25, 'H'),
direction='forward')
print (df)
A B
2019-12-02 1.000000 NaN
2019-12-04 1.020100 A
2019-12-05 1.030301 B
2019-12-06 1.040604 C
2019-12-09 1.051010 NaN
2019-12-10 1.061520 D
添加回答
舉報
0/150
提交
取消