prabjyotsudan
12/27/2017 - 7:40 AM

Date Time

Date Time Manipulation in Python

#month and day order
month_order = ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec']
day_order = ['Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat', 'Sun']

#converting unix to human readable form
import datetime
df['film_date'] = df['film_date'].apply(lambda x: datetime.datetime.fromtimestamp(int(x)).strftime('%d-%m-%Y'))
df['published_date'] = df['published_date'].apply(lambda x: datetime.datetime.fromtimestamp(int(x)).strftime('%d-%m-%Y'))

#analysis based on month and year
df['month'] = df['film_date'].apply(lambda x: month_order[int(x.split('-')[1]) - 1])

#analysis based on the day of the month
def getday(x):
    day,month,year = (int(i) for i in x.split('-'))
    answer = datetime.date(year, month, day).weekday()
    return day_order[answer]

df['day'] = df['film_date'].apply(getday)