How to Convert a String Column to Datetime in Pandas?

Converting DataFrame Column Type from String to Datetime

Problem: How do we convert a DataFrame column containing strings in dd/mm/yyyy format to the datetime data type?

Solution:

The convenient method for this task is utilizing Pandas' to_datetime function:

df['col'] = pd.to_datetime(df['col'])

This method provides a dayfirst argument for accommodating European date formats.

Example:

In [11]: pd.to_datetime(pd.Series(['05/23/2005']))
Out[11]:
0   2005-05-23 00:00:00
dtype: datetime64[ns]

Specifying a custom format is also possible:

In [12]: pd.to_datetime(pd.Series(['05/23/2005']), format="%m/%d/%Y")
Out[12]:
0   2005-05-23
dtype: datetime64[ns]

The above is the detailed content of How to Convert a String Column to Datetime in Pandas?. For more information, please follow other related articles on the PHP Chinese website!