1. Learn
    2. /
  2. Courses
    3. /
  3. Data Manipulation with pandas

Exercise

Pivoting on one variable

Pivot tables are the standard way of aggregating data in spreadsheets.

In pandas, pivot tables are essentially another way of performing grouped calculations. That is, the .pivot_table() method is an alternative to .groupby().

In this exercise, you'll perform calculations using .pivot_table() to replicate the calculations you performed in the last lesson using .groupby().

sales is available and pandas is imported as pd.

Instructions 1/3

undefined XP
  • 1
    • Get the mean weekly_sales by type using .pivot_table() and store as mean_sales_by_type.
  • 2
    • Get the mean and median (using NumPy functions) of weekly_sales by type using .pivot_table() and store as mean_med_sales_by_type.
  • 3
    • Get the mean of weekly_sales by type and is_holiday using .pivot_table() and store as mean_sales_by_type_holiday.