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 vote274 views1 answer
_getfullpathname: path should be string, bytes or os.PathLike, not list
Python
0 vote275 views1 answer
Sklearn pipeline with interactions python
Python
0 vote282 views2 answers
Python - Comment vérifier une corde contient un nombre
Python
5 votes265 views1 answer
Python check if class has function
Python
1 vote271 views1 answer
Check the input format of a date python
Python
1 vote318 views1 answer
Program to segregate positive and negative numbers in same list
Python
0 vote249 views1 answer
Create series with number intervals
Python
0 vote302 views1 answer
Python jinja2 from string
Python
0 vote295 views5 answers
Convert c++ code to python
Python
0 vote269 views1 answer
Saving a copy of rcParams settings.
Python