/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 vote326 views1 answer
Boto 3 list EMR
Python
18 votes342 views3 answers
Tkinter make window not resizable
Python
0 vote341 views1 answer
How to use rbind() to combine dataframes
Python
-1 vote316 views1 answer
Colours seaborn
Python
0 vote396 views1 answer
How to get data from json web api in python
Python
0 vote374 views1 answer
Check permissions django template
Python
0 vote414 views1 answer
Flask remove file after send_file
Python Flask
-2 votes358 views1 answer
Numpy find index of matching values
Python
0 vote322 views1 answer
List all subdirectories up to a level
Python
1 vote296 views2 answers
Download pdf from url python
Python