/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

2 votes372 views1 answer
Sacar la posicion en una lista python
Python
0 vote347 views1 answer
Wx.SingleInstanceCheckerindexmodules
Python
0 vote367 views1 answer
Python from string to bytes to hex
Python
2 votes388 views1 answer
Pathlib path get directory of current file
Python
2 votes354 views1 answer
Python add 1 to count
Python
1 vote375 views1 answer
Use django taggit in template
Python Django
0 vote369 views1 answer
Pytorch rolling window
Python
0 vote329 views1 answer
Stores number in set using input in python
Python
12 votes336 views3 answers
Get size of window tkinter
Python
0 vote390 views2 answers
Python faculty of 0 is 1 faculty of 1 is 1
Python