/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

6 votes130 views3 answers
Python data type conversion
Python
0 vote142 views1 answer
How to download feature engine in spyder console
Python
0 vote150 views1 answer
Bar chart with x-ticks
Python
0 vote159 views1 answer
How do I merge two dictionaries in a single expression (taking union of dictionaries)?
Python
18 votes144 views2 answers
Import local module python
Python
0 vote153 views1 answer
How to keep old content when using write in python
Python
2 votes145 views3 answers
How to set background image in python tkinter
Python
-3 votes127 views1 answer
Find key by value python
Python
11 votes135 views5 answers
Python Ordered Dictionary
Python
-2 votes146 views1 answer
Python for-while
Python