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

0 vote177 views1 answer
Read the entire text file using the read() function
Python
1 vote191 views1 answer
Create 2d list dictionary
Python
0 vote176 views1 answer
Loop on dataframe lines python
Python
0 vote161 views1 answer
Encoding read_csv
Python
3 votes167 views1 answer
Change plot size matplotlib python
Python
1 vote176 views1 answer
Log base 2 python
Python
1 vote176 views2 answers
Adding numbers in python
Python
0 vote175 views1 answer
Remove dict last element
Python
7 votes154 views6 answers
Get weekday from date python
Python
9 votes178 views1 answer
Delete model object django
Python Django