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

2 votes300 views1 answer
Python method to check for uppercase character
Python
0 vote285 views1 answer
Serversocket.accept() python
Python
2 votes297 views1 answer
Code to change default browser to chrome in web browser module
Python
-1 vote318 views1 answer
How to find root value python
Python
1 vote293 views1 answer
Last 24 hour python datetime
Python
9 votes309 views3 answers
How to join tables in python
Python
-1 vote313 views1 answer
Return an RDD with the keys of each tuple.
Python
4 votes281 views2 answers
Selenium chrome python
Python
0 vote329 views1 answer
Python get weather temperature
Python
-2 votes284 views1 answer
What does waka waka mean
Python