在現(xiàn)有的數(shù)據(jù)幀中;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我想添加一個(gè)基于現(xiàn)有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結(jié)果;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現(xiàn)有數(shù)據(jù)幀中的間隔也可以小于 24 小時(shí)。
1 回答
慕的地8271018
TA貢獻(xiàn)1796條經(jīng)驗(yàn) 獲得超4個(gè)贊
使用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
添加回答
舉報(bào)
0/150
提交
取消