Get startedGet started for free

Fill in missing values and sum values with pivot tables

The .pivot_table() method has several useful arguments, including fill_value and margins.

  • fill_value replaces missing values with a real value (known as imputation). What to replace missing values with is a topic big enough to have its own course (Dealing with Missing Data in Python), but the simplest thing to do is to substitute a dummy value.
  • margins is a shortcut for when you pivoted by two variables, but also wanted to pivot by each of those variables separately: it gives the row and column totals of the pivot table contents.

In this exercise, you'll practice using these arguments to up your pivot table skills, which will help you crunch numbers more efficiently!

sales is available and pandas is imported as pd.

This exercise is part of the course

Data Manipulation with pandas

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# Print mean weekly_sales by department and type; fill missing values with 0
print(sales.pivot_table(____))
Edit and Run Code