/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 vote209 views1 answer
Extract only year from date python
Python
0 vote224 views1 answer
Dataflair python
Python
0 vote201 views1 answer
Word counter python
Python
0 vote207 views1 answer
Time.ctime(os.path.getmtime phyton in datetime
Python
0 vote219 views1 answer
How to make a python file that prints out a random element from a list
Python
0 vote215 views2 answers
Historical tick bid ask
Python
2 votes203 views1 answer
Make tkinter window look less blury
Python
0 vote237 views1 answer
Django clear _pycache_ command
Python Django
0 vote202 views1 answer
Django less than and greater than
Python
36 votes205 views4 answers
Print colored text to console python
Python