/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 vote299 views2 answers
Python combine two lists into matrix
Python
4 votes344 views1 answer
Python django shell command
Python Django
0 vote297 views1 answer
Save python pptx in colab
Python
0 vote277 views1 answer
Open python choose encoding
Python
0 vote298 views1 answer
What is tensor in deep learning
Python
11 votes312 views2 answers
Find character in python
Python
1 vote319 views1 answer
Python access modifiers
Python
1 vote291 views1 answer
Python zeros to nan
Python
3 votes314 views1 answer
Streamlit ssl error
Python
0 vote296 views5 answers
Generator expressions python
Python