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

17 votes182 views4 answers
Flask render_template
Python
1 vote214 views1 answer
Tf.contrib.layers.xavier_initializer() tf2
Python
0 vote214 views1 answer
Data format pandas
Python
0 vote217 views1 answer
Tensor to int python
Python
3 votes235 views3 answers
Run a shell script from python
Python
0 vote214 views1 answer
Form rendering options in django
Python
0 vote212 views1 answer
How to start a working to run a particular queue
Python
0 vote193 views1 answer
Python import file from same level
Python
0 vote212 views2 answers
Browser = webdriver.firefox() error
Python
1 vote197 views1 answer
Flask enumerate index
Python