/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

92 votes140 views6 answers
String to datetime
Python
0 vote134 views1 answer
Tqb separator csv
Python
9 votes128 views3 answers
How to convert lower case to upper case in python
Python
1 vote160 views1 answer
Scikit learn split data set
Python
3 votes153 views1 answer
Remove commas from string python
Python
9 votes140 views1 answer
Area of triangle
Python
4 votes140 views3 answers
How to create a list from csv python
Python
1 vote138 views1 answer
Library for converting text into image in python
Python
15 votes145 views3 answers
How to delete in python
Python
3 votes186 views2 answers
How to install terminal in atom
Python