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

1 vote291 views1 answer
Use sqlalchemy to create sqlite3 database
Python
87 votes263 views6 answers
For loops python
Python
0 vote270 views1 answer
Scree plot sklearn
Python
4 votes245 views1 answer
Df.sort_values(by='col1',asending=True)
Python
26 votes261 views5 answers
Display max rows pandas
Python
0 vote299 views1 answer
Flask app with spark
Python Flask
0 vote277 views1 answer
Tkinter how to update optionmenu contents
Python
0 vote279 views3 answers
Make first row column names pandas
Python
0 vote259 views2 answers
Random seed generator minecraft
Python
11 votes262 views2 answers
Or condition in pandas
Python