/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

50 votes377 views1 answer
How to find item in list python without indexnig
Python
0 vote339 views1 answer
Loop indexing
Python
84 votes369 views2 answers
Python - save file
Python
0 vote350 views1 answer
Exit a pygame program
Python
3 votes382 views1 answer
Python substitute multiple letters
Python
1 vote377 views1 answer
R2 score sklearn
Python
2 votes353 views1 answer
How to add headings to data in pandas
Python
0 vote342 views1 answer
Find the place of element in list python
Python
0 vote379 views1 answer
Logartim normalization python pandas
Python
9 votes349 views4 answers
Multiple lines input python
Python