Calculate datetime difference in years, months, etc. in a new pandas dataframe column December 21, 2023 by Tarik You can try by creating a new column with years in this way: df['diff_year'] = df['diff'] / np.timedelta64(1, 'Y')