/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 vote119 views1 answer
Timeit command line
Python
2 votes147 views1 answer
Python Crash Course, 2nd Edition: A Hands-On, Project-Based Introduction to Programming
Python
3 votes175 views2 answers
Numpy count the number of 1s in array
Python
0 vote147 views1 answer
How to take long input in python
Python
36 votes158 views6 answers
Move file python
Python
34 votes163 views2 answers
Train-test split code in pandas
Python
48 votes154 views3 answers
Online python compiler with modules
Python
6 votes139 views1 answer
Save and load a dictionary python
Python
0 vote108 views1 answer
Pygame triangle
Python
1 vote145 views1 answer
Ax tick params
Python