/Python/Pandas splitting the data based on the day type

Pandas splitting the data based on the day type

day['hour'] = day['date_time'].dt.hour
bussiness_days = day.copy()[day['dayofweek'] <= 4] # 4 == Friday
weekend = day.copy()[day['dayofweek'] >= 5] # 5 == Saturday
by_hour_business = bussiness_days.groupby('hour').mean()
by_hour_weekend = weekend.groupby('hour').mean()

print(by_hour_business['traffic_volume'])
print(by_hour_weekend['traffic_volume'])

-1

Source: app.dataquest.io

Similar codes

0 vote102 views1 answer
Sqlalchemy datetime default now create table
Python
17 votes107 views2 answers
Make tkinter button disable
Python
0 vote107 views2 answers
Pandas apply check for string length in column
Python
0 vote127 views1 answer
Pip choose interpreter
Python
0 vote111 views1 answer
Comentar codigo en python
Python
6 votes119 views1 answer
Np euclidean distance python
Python
1 vote121 views2 answers
Python easter egg
Python
6 votes126 views5 answers
No module named env.__main__; 'env' is a package and cannot be directly executed
Python
0 vote104 views1 answer
How to use drop for file in python
Python
5 votes116 views3 answers
Os system python
Python