[Python] AttributeError: Can only use .dt accessor with datetimelike values. Did you mean:...

I have been writing a python script using Atom, but because of issues rendering plots transitioned over to PyCharm with a virtual enviroment.

Part of the script includes the following:

df['date1'] = pd.to_datetime(df['date1'], format='%d%b%Y', errors='raise').dt.date
df['date2'] = pd.to_datetime(df['date2'], format='%d%b%Y', errors='raise').dt.date

df['diff'] = (df['date1'] - df['date2']).dt.days/30


It runs entirely fine on Atom, but on PyCharm I get the following error: AttributeError: Can only use .dt accessor with datetimelike values. Did you mean: 'at'?

I've seen similar questions where the errors has been raised due to a data issue & hence added errors='raise' but which raises no errors.

I presume given the error is related to the differing IDE it may be due to different versions of packages, but as far as I can tell they are the same and so am unsure on the cause/how to fix it.

Continue reading...