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

17 votes270 views6 answers
Django model
Python Django
74 votes242 views4 answers
Reverse function python
Python
0 vote256 views1 answer
How to crack a 4 way handshake with python
Python
1 vote238 views3 answers
Pandas add column from list
Python
0 vote238 views1 answer
Django content type for model
Python Django
41 votes238 views6 answers
Replace nan with 0 pandas
Python
22 votes238 views5 answers
Python import file from different directory
Python
0 vote258 views1 answer
To create a SparkSession
Python
3 votes232 views1 answer
Django user group check
Python
2 votes253 views2 answers
Conda create jupyter kernel
Python