Some values for date_added in the dataset have a leading space. I assume different pandas versions deal different with this. Using pandas 2.2.3 the solution of iBeMeltin does not work for me. However

pd.to_datetime(df['date_added'].str.strip(), format='%B %d, %Y')

works.