In [18]:

    

import pandas as pd
import datetime


    

In [19]:

    

data = pd.read_csv('FinalMerge.csv',encoding='latin1')


    

In [20]:

    

# index of released date col
index = data.columns.get_loc("Released")
#change date data to timestamp
date_list = pd.to_datetime(data["Released"])


    

In [26]:

    

# released date is weekend of not
weekend_list = []
for each in date_list:
    day_ofweek = each.dayofweek
    if day_ofweek >= 4 and day_ofweek <= 6:
        tag = 1
    else:
        tag = 0
    weekend_list.append(tag)