/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

9 votes143 views20 answers
Tkinter python
Python
3 votes169 views1 answer
Python Program to check for balanced parentheses in an expression using stack class.
Python
-1 vote163 views1 answer
Request foucus tkinter widget
Python
0 vote165 views2 answers
Logger
Python
0 vote158 views1 answer
Mechanize python XE #29
Python
0 vote163 views1 answer
Declare pandas dataframe with values
Python
2 votes168 views4 answers
Python dict get random key
Python
0 vote171 views1 answer
Blender python set object location
Python
0 vote175 views1 answer
Merge subplot matplotlib
Python
0 vote159 views1 answer
Convert list to tree python
Python