How to parse dates to datetime format in Pandas?

Question

Python

There is a dataframe in which the Order Date column is a string.
I want to convert it to datetime using the code below, but it doesn't work.

dates['Datka'] = pd.to_datetime(df['Order Date'], format='%m/%d/%Y %X')

Maybe I'm formatting it wrong somehow? Explain, please

Answer 1

You can immediately when reading the file:

from datetime import datetime

dateparser = lambda x: datetime.strptime(x, "%m/%d/%y %H:%M")

df = pd.read_csv('filename.csv', parse_dates = ['Order Date'], date_parser=dateparser)

Also corrected the format to match the data in the column