I am converting a date dataframe column from str to date, where I am using the following code, since the date format that I thought was 2018-05-13:
datetime.strptime(embebido_equipart.iloc[i]['primerPartido'],"%Y-%m-%d")
So far so good, but I get an error that there are several date formats in the same column, such as 05/10/2020. Would there be a way to change all the dates at once even if they have different formats?
Having several different formats mixed in the same column makes it difficult for me to change it at once, and I wouldn't know how to do it.
The error that I get is the following, where it tells me that the format I have chosen is not correct:
time data '21/04/1900' does not match format '%Y-%m-%d'