/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 vote195 views1 answer
Truncatechars django
Python
5 votes193 views2 answers
Making variable if it is none python
Python
0 vote155 views1 answer
Python max function with lambda
Python
0 vote157 views1 answer
Python convert png to jpg
Python
0 vote163 views1 answer
Permission denied when converting dataframe to csv
Python
0 vote163 views1 answer
Nested for loop table python
Python
0 vote177 views1 answer
Move one column value down by one column in pandas
Python
1 vote156 views1 answer
ValueError: cannot mask with array containing NA / NaN values
Python
0 vote164 views1 answer
Matplotlib styles attr
Python
26 votes184 views6 answers
Python remove whitespace from start of string
Python