date_related_manipulations.py

#Breakdown Date fields and convert other fields to integer
data['Date'] = pd.to_datetime(data['Date'], format='%d/%m/%Y')
data['Day_of_week'] = pd.DatetimeIndex(data['Date']).dayofweek
data["Is Weekday"] = (data['Day_of_week'] < 5)
data["Is Weekend"] = (data['Day_of_week'] > 4)
days = {0: 'Mon', 1: 'Tue', 2: 'Wed', 3: 'Thu', 4: 'Fri', 5: 'Sat', 6: 'Sun'}
DayCodes = ['','Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat', 'Sun']