/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

4 votes144 views1 answer
Python open and read file with
Python
17 votes240 views6 answers
Installing django
Python Django
0 vote149 views1 answer
Select first row of every group pandas
Python
0 vote164 views1 answer
A.all() numpy
Python
1 vote172 views1 answer
Multirow np.rand.randint
Python
4 votes204 views5 answers
Min max python
Python
3 votes161 views1 answer
Tkinter labelframe
Python
11 votes146 views2 answers
Renpy
Python
0 vote163 views1 answer
Extract nonzero array elements python
Python
0 vote164 views1 answer
Pandas insert a list into cell
Python