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 votes139 views3 answers
Remove x label matplotlib
Python
0 vote129 views1 answer
Linux pyspark select java version
Python
0 vote166 views1 answer
User passes test django
Python Django
3 votes171 views2 answers
Django timezone india
Python Django
1 vote144 views1 answer
Python rickroll code
Python
1 vote144 views2 answers
How to calculate chi square in python
Python
15 votes142 views3 answers
Clear window python console
Python
0 vote143 views1 answer
Get the invite url of server disc.py
Python
2 votes152 views3 answers
How to sum digits of a number in python
Python
0 vote136 views1 answer
Django fixtures. To loaddata
Python