I'm stuck trying to figure how to parse this object containing date that is formatted as 18.26.01 (object formatted with periods) in pandas. I'm using the pd.to\_datetime(youtube\_US['trending\_date']) method but it's returning a parsing error. The error is as follows:
ParserError: month must be in 1..12: 17.14.11
How do I parse this date so that it returns a proper datetime object? Do I need to use any kind of loop?