How to Convert a String Column to Datetime in a Pandas DataFrame?

Converting DataFrame Column from String to Datetime

Problem:

How to convert DataFrame Convert a string column in (format dd/mm/yyyy) to datetime data type?

Answer:

The simplest way to convert is to use to_datetime:

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

It also provides a dayfirst parameter for handling Europe time (but this is not strict).

The actual application is as follows:

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

In addition, you can also specify a specific format:

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 a Pandas DataFrame?. For more information, please follow other related articles on the PHP Chinese website!