idx = pd.date_range(start='2018-01-01', freq='D', periods=3) idx.day_name() >> Index(['Monday', 'Tuesday', 'Wednesday'], dtype='object')
df['Date'].dt.day_name()