Fortunately, this issue can be easily fixed. The .to_datetime() method has yearfirst and dayfirst boolean parameters that define whether dates start with the year or day, respectively. By default, both parameters are set to False, which is why the first numbers were considered as months (if possible). Since the dates in our data start with the day, we just need to set the dayfirst parameter to True.