change column data type to date when only year available pandas

Question

The colum data which is year has only year( int64) ex 1961 and not as 1961-01-01 when I try to chage to date formate as

dfda['Founded']= pd.to_datetime(dfda['Founded'])

the output is 1970-01-01 00:00:00.000001961 which is wrong , is there any simple way or should we reformate the column to 1961-01-01

Use `dfda['Founded']= pd.to_datetime(dfda['Founded'], format='%Y')` — jezrael, Oct 01 '20 at 09:29

score 1 · Answer 1 · answered Oct 01 '20 at 09:31

1

You could try

  str(dfda['Founded'])

answered Oct 01 '20 at 09:31

Himanshu

1 Answers1