Weekday pandas

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,

Weekday pandas

df['date_time'].dt.dayofweek #gives only the index(0-monday,6-sunday)
df['date_time'].dt.weekday_name #gives the day

Similar codes

3 votes215 views2 answers
Find frequency of numbers in list python
Python
8 votes200 views1 answer
Remove too short strings from a list python
Python
0 vote229 views1 answer
Precision and recall from confusion matrix python
Python
0 vote199 views2 answers
Quotation marks in string
Python
0 vote303 views1 answer
Django test imagefield
Python Django
1 vote189 views1 answer
Nlargest hierarchy series pandas
Python
1 vote246 views2 answers
How to get the number of rows and columns in a numpy array
Python
6 votes196 views1 answer
Numpy round
Python
0 vote298 views1 answer
Credential not provided when i try to sign up a new user django
Python Django
1 vote222 views1 answer
Qpushbutton text alignment
Python