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

3 votes147 views2 answers
Count how many vowels in a string python
Python
1 vote178 views1 answer
SystemError: tile cannot extend outside image
Python
5 votes155 views3 answers
Learn python the hard way
Python
0 vote164 views5 answers
Difference between cut and qcut pandas
Python
0 vote144 views1 answer
Reassign variable python
Python
2 votes140 views3 answers
Discord.py clear
Python
9 votes147 views4 answers
Python combinations function
Python
42 votes144 views6 answers
If key in dictionary python
Python
0 vote177 views1 answer
Redirect a post request django
Python
0 vote162 views1 answer
Python find all occurrence in string
Python