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

12 votes102 views3 answers
Write list to text file python
Python
1 vote132 views1 answer
No module named 'bidi'
Python
0 vote176 views1 answer
Django request.data example
Python Django
0 vote130 views1 answer
How to import the whall library in python
Python
1 vote159 views1 answer
How to download excel file from s3 using python
Python
0 vote144 views1 answer
How to use rbind() to combine dataframes
Python
0 vote153 views1 answer
Detect operating system using python
Python
1 vote132 views1 answer
Module "django.contrib.auth.hashers" does not define a "BcryptPasswordHasher" attribute/class
Python
81 votes139 views4 answers
Python wait for x seconds
Python
1 vote106 views1 answer
Get json data python
Python