Weekday pandas

Convert pandas datetime to day, weekday, month

#Convert datetime column/series to hour of the day. NB: Column must be in datetime format.
df['hour'] = df['column_name'].dt.hour
#Convert datetime column/series to day of the week
df['day'] = df['column_name'].dt.weekday
#Convert datetime column/series to month
df['month'] = df['column_name'].dt.month
#Convert datetime column/series to year
df['year'] = df['column_name'].dt.year
#NB: Weekday/Month will be in int. Eg. for months, January=1, February=2...etc,

Weekday pandas

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

Similar codes

0 vote152 views1 answer
Dataframe rolling first eleemnt
Python
8 votes183 views1 answer
Python how to listen to keyboard
Python
0 vote157 views4 answers
Client network socket disconnected before secure TLS connection was established
Python
2 votes173 views2 answers
Null=true django
Python Django
52 votes163 views6 answers
Sort a dictionary
Python
1 vote164 views1 answer
Module turtle has no forward member
Python
0 vote147 views1 answer
Dataframe plot conditional formatting
Python
1 vote143 views2 answers
Get timestamp from string python
Python
1 vote167 views1 answer
Price for bazaar item hypixel python
Python
0 vote155 views2 answers
How to avoid inserting duplicate records in orm django
Python