Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- id int_date
- 1 20160228
- 2 20161231
- 3 20160618
- 4 20170123
- 5 20151124
- id int_date
- 1 02/28/2016
- 2 12/31/2016
- 3 06/18/2016
- 4 01/23/2017
- 5 11/24/2015
- date = datetime(year=int(s[0:4]), month=int(s[4:6]), day=int(s[6:8]))
- from datetime import datetime
- a = '20160228'
- date = datetime.strptime(a, '%Y%m%d').strftime('%m/%d/%Y')
- def get_datetime(date):
- date_string = str(date)
- return datetime.date(date_string[:3], date_string[4:6], date_string[6:8]
- import pandas as pd
- dates = [
- 20160228,
- 20161231,
- 20160618,
- 20170123,
- 20151124,
- ]
- df = pd.DataFrame(data=list(enumerate(dates, start=1)), columns=['id','int_date'])
- df[['str_date']] = df[['int_date']].applymap(str).applymap(lambda s: "{}/{}/{}".format(s[4:6],s[6:], s[0:4]))
- print(df)
- $ python test.py
- id int_date str_date
- 0 1 20160228 02/28/2016
- 1 2 20161231 12/31/2016
- 2 3 20160618 06/18/2016
- 3 4 20170123 01/23/2017
- 4 5 20151124 11/24/2015
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement