Pd.to_datetime() not working on a column with different date formats

See more:

Python

DateTime

DataFrame

I wrote a program where a dataframe is traversed & when any column with the name 'Date' is encountered, all the rows under that column are supposed to be converted to a 'datetime' object using 'pd.to_datetime' in the format mentioned. But this method is not working for me.

The 'Date' column in my dataset consists of dates in various formats & with different separators. When I do debugging I get an error message for those dates that are not in the format specified.

Isn't the whole point of using the method a way to convert dates in any format to a datetime object & in the format specified?

What I have tried:

from dateutil.parser import parse
import re
from datetime import datetime
import calendar

import pandas as pd

def date_fun(filepath):
     
   date_list=['Date', 'date', 'Dates', 'dates']
   
   for i in filepath.columns:
 
      for j in date_list:     
          if i==j:
            filepath[i]=pd.to_datetime(filepath[i], format='%d-%m-%Y')
           
                                                                         

main_path = pd.read_csv('C:/Data_Cleansing/lockdown_us.csv')
fpath=main_path.copy()


Error: time data '26-2016-09' does not match format '%d-%m-%Y' (match)
Where is the mistake in my code?