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

0 vote272 views1 answer
Mean along third dimension array python
Python
-1 vote270 views1 answer
How to split a string into a dictionary in Python
Python
4 votes313 views2 answers
Timeout socket python
Python
0 vote289 views1 answer
Save changes flask sqlalchemy
Python
0 vote295 views10 answers
Python
Python
0 vote295 views1 answer
How to assign a new value in a column in pandas dataframe
Python
0 vote302 views1 answer
Torch print floating precision
Python
0 vote280 views1 answer
Resize a Turtle object
Python
-1 vote298 views1 answer
Python remove \t
Python
12 votes322 views3 answers
Python pandas read_csv tsv
Python