#we extract day of week from "2016-10-07" type data df['dayofweek'] = df['effective_date'].dt.dayofweek
