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 vote212 views1 answer
Jointplot title
Python
0 vote194 views1 answer
Python list.append string return empty
Python
0 vote198 views1 answer
Last 2 numbers of integer in python
Python
0 vote188 views1 answer
Make_interp_spline
Python
3 votes191 views2 answers
Set Intersection
Python
4 votes193 views1 answer
Fixed precision float python
Python
0 vote266 views2 answers
Remove rows if not matching with value in df
Python
0 vote205 views1 answer
How to read docx file in python
Python
0 vote242 views1 answer
AttributeError: 'NoneType' object has no attribute 'dropna'
Python
0 vote201 views1 answer
Python lists as dataframe rows
Python