Converting Integers to Dates

Question

I have datasets which have the dates in the format of yyyymmdd. For example, May 5th, 2018 would be 20180505.

How can I reformat these entries such that they will be a time series in pandas?

Possible duplicate of [Convert integer (YYYYMMDD) to date format (mm/dd/yyyy) in python](https://stackoverflow.com/questions/43133605/convert-integer-yyyymmdd-to-date-format-mm-dd-yyyy-in-python) — rafaelc, May 06 '18 at 06:30
Possible duplicate of [How to convert integer into date object python?](https://stackoverflow.com/questions/9750330/how-to-convert-integer-into-date-object-python) — harvpan, May 06 '18 at 15:30

score 1 · Answer 1 · answered May 06 '18 at 05:50

1

Try this:

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

From this link: Convert integer (YYYYMMDD) to date format (mm/dd/yyyy) in python

answered May 06 '18 at 05:50

iRhonin

383
3
14

score 0 · Answer 2 · answered May 06 '18 at 05:57

0

You could find everything on pandas docs. Read about datetime in pandas,

## sample data
df = pd.DataFrame({'dates': ['20180505','20180506','20180507','20180508']})

## convert to dates
df['dates'] = pd.to_datetime(df['dates'])

answered May 06 '18 at 05:57

YOLO

20,181
5
20
40

score 0 · Answer 3 · answered May 06 '18 at 07:49

You may want also to change the format and this is an example:

df = pd.DataFrame({'dates': ['20180505','20180506','20180507','20180508']})
print df
      dates
0  20180505
1  20180506
2  20180507
3  20180508
df['dates'] =  pd.to_datetime(df['dates'], format='%Y%m%d').dt.strftime('%d/%b/%Y')
print df

Output:

         dates
0  05/May/2018
1  06/May/2018
2  07/May/2018
3  08/May/2018

Converting Integers to Dates

3 Answers3