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

2 votes204 views1 answer
Finding if user input is lower or upper in python
Python
0 vote146 views1 answer
How to see a full row in pandas
Python
7 votes131 views2 answers
Make a condition statement on column pandas
Python
0 vote143 views1 answer
List comprehensions with dates
Python
24 votes155 views1 answer
Python datetime strptime hour minute second
Python
0 vote148 views1 answer
Make value of two tables unique django
Python
0 vote139 views1 answer
Required depend filed odoo
Python
0 vote121 views1 answer
How to add to beginning of linked list python
Python
4 votes137 views1 answer
Np.random.float
Python
0 vote140 views2 answers
How to read xlsx file in jupyter notebook
Python