I have the following one-column Pandas data frame:
JavaScript
x
7
1
num_days
2
--------
3
9236
4
9601
5
9636
6
10454
7
Here the integers are number of days counted from a constant predefined date:
JavaScript
1
2
1
START_DATE = pd.to_datetime('1980-01-01')
2
Now I want to have a column with dates (calculated as START_DATE
+ the respective num_days
) like this:
JavaScript
1
7
1
num_days, date
2
--------------
3
9236 '2005-04-15'
4
9601 '2006-04-15'
5
9636 '2006-05-20'
6
10454 '2008-08-15'
7
I have tried this:
JavaScript
1
2
1
df['date'] = pd.to_datetime('1980-01-01') + timedelta(df.num_days)
2
but no success:
JavaScript
1
2
1
TypeError: unsupported type for timedelta days component: Series
2
Advertisement
Answer
JavaScript
1
2
1
df["date"] = pd.to_datetime('1980-01-01') + pd.to_timedelta(df["num_days"], unit="D")
2