I have two columns with date and I need to create another based on sum of those two. df looks like below:
date_1 date_2 result_date
2024-07-07 18:00:00.000000 0001-01-02T01:12:53.832 2024-07-08 19:12:53
2024-07-07 08:46:00.000000 0001-01-04T08:00:00 2024-07-10 16:46:00
2024-07-07 17:42:00.000000 0001-01-08T02:00:00 2024-07-14 19:42:00
2024-07-07 17:42:00.000000 0002-01-01T02:00:00 2025-07-07 19:42:00
The type of date_1 and date_2 columns are “object”. In date_2 column, the code shows date from year one. I am not sure how I could add them.