I have a column "DateBecameRep_Year" that contains only year values in it (i.e. 1974, 1999, etc.). I want to create a new column in my dataframe that calculates the difference between the current year and the year in the "DateBecameRep_Year" field.
Below is the code I tried to use:
df_DD['DateBecameRep_Year'] = pd.to_datetime(df_DD['DateBecameRep_Year'])
df_DD['Current Year'] = datetime.now().year
df_DD['Current Year'] = pd.to_datetime(df_DD['Current Year'])
df_DD['Years_Since_BecameRep'] = df_DD['Current Year'] - df_DD['DateBecameRep_Year']
df_DD['Years_Since_BecameRep'] = df_DD['Years_Since_BecameRep'] / np.timedelta64(1, 'Y')
df_DD['Years_Since_BecameRep'].head()
This is the output I get which looks very strange:
My hypothesis is that this has something to do with the following:
Any help is greatly appreciated!