/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

37 votes137 views1 answer
Time format conversion in python
Python
-1 vote165 views1 answer
The field was declared on serializer, but has not been included in the 'fields' option
Python
12 votes177 views1 answer
Python check namespace has instance
Python
1 vote173 views1 answer
How to play sound after pressing a button in tkinter
Python
0 vote235 views1 answer
Free the Bunny Prisoners
Python
-1 vote133 views1 answer
Car python program
Python
3 votes103 views1 answer
Python re match
Python
0 vote135 views1 answer
Python how to invert an array
Python
11 votes152 views2 answers
That does 1:to:3 do Python ?
Python
2 votes142 views2 answers
Numpy count where
Python