Convert year into datetime format pandas

Question

I have a dataframe as shown below

Name       Birth_Year
Messi      2007
Ronaldo    2004

I would like to convert that Birth_Year into date.

Expected Output

Name    Birt_Year      Birth_Date
Messi   2007.0         2007-01-01
Ronaldo 2004.0         2004-01-01

I tried below code

df1['Year'] = pd.to_datetime(df1['Birt_Year'], format='%Y%m%d.0', errors='coerce')

Erfan · Accepted Answer · 2019-12-26 11:59:18Z

3

You were almost there, your format is just %Y, since you only have year on your Birth_Year column:

df['Birth_Date'] = pd.to_datetime(df['Birth_Year'], format='%Y')

      Name  Birth_Year Birth_Date
0    Messi        2007 2007-01-01
1  Ronaldo        2004 2004-01-01

answered Dec 26, 2019 at 11:59

Erfan

43.3k10 gold badges75 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert year into datetime format pandas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related