python - 添加天数后如何获取日期：TypeError：timedelta天数组件不支持的类型：系列

Question

在实际日期中添加几天后，我试图获得一个新日期。但我收到以下错误：

TypeError: unsupported type for timedelta days component: Series

下面提供了我的示例数据和代码：

data={'Date':['8/24/2020','8/26/2020','9/20/2020','10/26/2020','5/26/2020','4/26/2020'],
     'Days':[23,34,56,78,65,54]}
df=pd.DataFrame(data,columns=['Date','Days'])
df.Date=pd.to_datetime(df.Date)
df.newdate=df.Date+timedelta(df.Days)

标签： pythonpandas

Answer 1

采用pd.to_timedelta

import pandas as pd

df['new_date'] = df.Date + pd.to_timedelta(df.Days, unit='d')

---

0   2020-09-16
1   2020-09-29
2   2020-11-15
3   2021-01-12
4   2020-07-30
5   2020-06-19
Name: new_date, dtype: datetime64[ns]