/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

22 votes252 views6 answers
How to take list input in python
Python
15 votes330 views4 answers
Django python install
Python Django
1 vote290 views1 answer
Formatting Dates
Python
23 votes248 views1 answer
Python minute from datetime
Python
16 votes262 views2 answers
Python nonlocal
Python
0 vote286 views2 answers
Wxpython menu callback stackoverflow
Python
0 vote262 views1 answer
Combine 3 jupyter cells together
Python
5 votes284 views3 answers
Python change column order in dataframe
Python
8 votes265 views2 answers
Flask.pocoo.org quickstart
Python
2 votes228 views1 answer
How to separate a string or int with comma in python
Python