/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

-1 vote324 views1 answer
Django template filter
Python Django
0 vote277 views4 answers
Food
Python
0 vote461 views1 answer
ImportError: cannot import name 'MigrateCommand' from 'flask_migrate'
Python Flask
0 vote335 views1 answer
Pyspark datetime add hours
Python
10 votes330 views3 answers
String to hex python
Python
0 vote312 views2 answers
Python counter least common
Python
1 vote343 views6 answers
Add item to tuple python
Python
0 vote308 views1 answer
Run multiple function with multiprocessing python
Python
13 votes301 views5 answers
How to make a timer using python
Python
0 vote323 views10 answers
C++ to python converter online
Python