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 vote234 views1 answer
Python django os error
Python Django
0 vote212 views2 answers
Extract email address using expression in django
Python
1 vote241 views1 answer
Getting multiple selected value django
Python
-1 vote209 views1 answer
Convert excel to json
Python
0 vote230 views2 answers
Python error: command 'x86_64-linux-gnu-gcc' failed with exit status 1
Python
1 vote211 views6 answers
How to hello world in python
Python
0 vote266 views1 answer
Write a python program to find fibonacci series upto a certain limit using while loop
Python
1 vote235 views2 answers
N factorial
Python
97 votes210 views6 answers
How to read a csv file in python
Python
82 votes252 views6 answers
Create virtualenv python3
Python