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

69 votes231 views6 answers
Python online compiler 3.8
Python
0 vote255 views2 answers
5.2.5: Counting 10 to 100 by ...
Python
1 vote226 views1 answer
Index of sorted list python
Python
0 vote257 views1 answer
How to switch driver in python selenium
Python
39 votes230 views3 answers
Increase figure size in matplotlib
Python
0 vote239 views1 answer
Python extract list from string
Python
0 vote246 views1 answer
How to use rbind() to combine dataframes
Python
7 votes230 views2 answers
Make a condition statement on column pandas
Python
0 vote258 views2 answers
Install python in centos7
Python
0 vote223 views1 answer
Matplotlib rc params
Python