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

1 vote425 views1 answer
Flask get value of radio button
Python Flask
0 vote360 views1 answer
Backend not found Request Method: GET Request URL: http://127.0.0.1:8000/oauth/login/google-oauth2/ Raised by: social_django.views.au
Python
0 vote368 views1 answer
Convert pandas group to dict
Python
0 vote359 views1 answer
Blockchain private key generator
Python
0 vote390 views1 answer
Split the string using the separator
Python
-2 votes335 views2 answers
Django form date picker
Python
0 vote366 views1 answer
Best scraping package in python
Python
0 vote354 views1 answer
How to check mix types in pandas column
Python
6 votes376 views2 answers
Flask docker
Python
110 votes334 views6 answers
Read text file in python
Python