/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 vote250 views1 answer
Apply 2d mask to 3d array python
Python
0 vote241 views1 answer
Functools.cached_property objects in python
Python
-1 vote248 views1 answer
Python split large xml file by tag
Python
5 votes245 views2 answers
Python get min max value from a dictionary
Python
6 votes247 views3 answers
Get particular columns from dataframe
Python
4 votes294 views1 answer
Django slug int url mapping
Python Django
0 vote242 views1 answer
How to do welcome in bubble letters in python
Python
1 vote237 views1 answer
Adding variable in python
Python
9 votes245 views1 answer
Print current dirfile dir python
Python
0 vote284 views1 answer
How to delete lists after using them in python
Python