python日期转换为整数,在python中将整数（YYYYMMDD）转换为日期格式（mm / dd / yyyy）...

I have following dataframe.

id int_date

1 20160228

2 20161231

3 20160618

4 20170123

5 20151124

How to convert above date in int format to date format of mm/dd/yyyy? Want this in particular format for further excel operations?

id int_date

1 02/28/2016

2 12/31/2016

3 06/18/2016

4 01/23/2017

5 11/24/2015

IS it also possible to generate third column with only Month in words? like January, February etc from int_date?

I tried following

date = datetime(year=int(s[0:4]), month=int(s[4:6]), day=int(s[6:8]))

but date is in datetime object, how to put it as date in pandas DF?

解决方案

You can use datetime methods.

from datetime import datetime

a = '20160228'

date = datetime.strptime(a, '%Y%m%d').strftime('%m/%d/%Y')

Good Luck;