/Python/Convert pandas datetime to day, weekday, month

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,

Similar codes

0 vote341 views1 answer
Python check if website is reachable
Python
7 votes393 views2 answers
From distutils.util import strtobool ModuleNotFoundError: No module named 'distutils.util'
Python
0 vote407 views1 answer
How to catch stop itteration in generator as None
Python
16 votes373 views4 answers
Python remove last instance of a list
Python
13 votes337 views5 answers
Get index of item in list
Python
0 vote368 views1 answer
Sikuli guide text
Python
0 vote401 views1 answer
Pivot table but keep nan
Python
1 vote328 views1 answer
Set size of button tkinter
Python
2 votes363 views1 answer
Add numpy array to pandas dataframe
Python
0 vote334 views1 answer
Subtract layers
Python