Get startedGet started for free

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

View Course

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])
Edit and Run Code