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 votes169 views4 answers
How to add array in python
Python
3 votes128 views1 answer
Best games made in pygame
Python
0 vote131 views1 answer
Delete history django simple
Python
0 vote132 views1 answer
Fibonacci sequence generator python
Python
0 vote114 views1 answer
Python extract words from string with format
Python
0 vote125 views1 answer
Get the values of your aws tags from ec2 instance
Python
1 vote124 views1 answer
How to get a list of followers on instagram python
Python
0 vote120 views2 answers
Python:Gann square of 9
Python
0 vote121 views1 answer
Getch backspace pytohn
Python
17 votes81 views3 answers
Get last row of dataframe
Python