/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

1 vote157 views1 answer
Python png library
Python
1 vote131 views1 answer
For i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):
Python
1 vote168 views1 answer
How to import data from csv to jupyter notebook
Python
14 votes128 views2 answers
What does related name do in django
Python
1 vote151 views1 answer
Jupyter notebook how to set max display row columns matrix numpy
Python
0 vote138 views1 answer
Import get object
Python
-2 votes160 views1 answer
Client server python socket
Python
2 votes143 views2 answers
Reverse an array pyton
Python
89 votes157 views4 answers
New env in conda
Python
26 votes151 views5 answers
How to square root in python
Python