Data filtration
As you noticed in the video lesson, you may need to filter your data for various reasons.
In this exercise, you will use filtering to select a specific part of our DataFrame:
- by the number of entries recorded in each day of the week
- by the mean amount of money the customers paid to the restaurant each day of the week
This exercise is part of the course
Writing Efficient Code with pandas
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Filter the days where the count of total_bill is greater than $40
total_bill_40 = restaurant_data.groupby('day').____(lambda x: ____[____].____() > 40)
# Print the number of tables where total_bill is greater than $40
print('Number of tables where total_bill is greater than $40:', total_bill_40.shape[0])