data['Occurrence Local Date Time']=pd.to_datetime(data['Occurrence Local Date Time'],dayfirst=True )
When converting the Occurance Date Time to datetime, Make sure you make dayFirst=True. If you don't do so, pandas would assume that the first digit of your date is a month.
'%3e%3cpath fill='%23001489' d='M0 0v6h9V0z'/%3e%3cpath fill='%23e03c31' d='M0 0v3h9V0z'/%3e%3cg stroke='%23fff' stroke-width='2'%3e%3cpath id='d' d='m0 0 4.5 3L0 6m4.5-3H9'/%3e%3cuse xlink:href='%23b' stroke='%23ffb81c' clip-path='url(%23c)'/%3e%3c/g%3e%3cuse xlink:href='%23d' fill='none' stroke='%23007749' stroke-width='1.2'/%3e%3c/g%3e%3c/svg%3e)
Can you please elaborate?
data['Occurrence Local Date Time']=pd.to_datetime(data['Occurrence Local Date Time'],dayfirst=True ) When converting the Occurance Date Time to datetime, Make sure you make dayFirst=True. If you don't do so, pandas would assume that the first digit of your date is a month.
I think you should update your Pandas version :D