我有以下数据框。
日期的类型是datetime64[ns, UTC]
announce_date announce_time
0 2013-01-23 After Market Close
1 2013-04-23 Before Market Open
2 2013-07-20 After Market Close
我如何创建一个新列,如果
announce_time
是"在市场收盘后"
,则将announce_date
偏移1个单位。 announce_date announce_time impact_date
0 2013-01-23 After Market Close 2013-01-24
1 2013-04-23 Before Market Open 2013-04-23
2 2013-07-20 After Market Close 2013-07-21
我可以创建一个偏移日期的列,但还没有想出如何应用条件。
import pandas as pd
df['impact_date'] = df['announce_date'] + pd.DateOffset(days=1)