CODEWITHSUNDEEP
pythonpandasdatetimedataframe
user7289
user7289

Reputation: 34318

Converting dates into pd.datetime

I have a pandas dataframe with dates in the following formats:

December 22, 2013
November 28, 2016
December 21, 2013
etc.

Whats the easiest way to convert them to a datetime?

Thanks in advance for any help!

Upvotes: 1

Views: 861

Answers (2)

jezrael
jezrael

Reputation: 862406

Use fomat from http://strftime.org/ for improve performance with to_datetime:

df['date'] = pd.to_datetime(df['date'], format='%B %d, %Y')

Or:

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

print (df)
        date
0 2013-12-22
1 2016-11-28
2 2013-12-21

Upvotes: 3

Rakesh
Rakesh

Reputation: 82755

Using to_datetime

Ex:

import pandas as pd

df = pd.DataFrame({"date": ['December 22, 2013', 'November 28, 2016', 'December 21, 2013']})
print( pd.to_datetime(df["date"]) )

Output:

0   2013-12-22
1   2016-11-28
2   2013-12-21
Name: date, dtype: datetime64[ns]

Upvotes: 1

Related Questions