/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 vote195 views5 answers
Print string python
Python
0 vote228 views1 answer
Rotate existing labels python
Python
0 vote203 views1 answer
Get index of value in list if value meet condition python
Python
34 votes233 views6 answers
How to open a file in python
Python
0 vote202 views1 answer
How to make a window in pyga,e
Python
18 votes276 views4 answers
Matplotlib histogram
Python
9 votes195 views1 answer
Save an image in python as grayscale cv2
Python
7 votes205 views2 answers
Python numpy matrix to list
Python
47 votes196 views3 answers
How to change an integer to a string in python permanently
Python
1 vote217 views1 answer
Yapf ignore line
Python