df['date_time'].dt.dayofweek #gives only the index(0-monday,6-sunday) df['date_time'].dt.weekday_name #gives the day