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

Exercise

Efficient summaries

While pandas and NumPy have tons of functions, sometimes, you may need a different function to summarize your data.

The .agg() method allows you to apply your own custom functions to a DataFrame, as well as apply functions to more than one column of a DataFrame at once, making your aggregations super-efficient. For example, 

df['column'].agg(function)

In the custom function for this exercise, "IQR" is short for inter-quartile range, which is the 75th percentile minus the 25th percentile. It's an alternative to standard deviation that is helpful if your data contains outliers.

sales is available and pandas is loaded as pd.

Instructions 1/3

undefined XP
  • 1
    • Use the custom iqr function defined for you along with .agg() to print the IQR of the temperature_c column of sales.
  • 2
    • Update the column selection to use the custom iqr function with .agg() to print the IQR of temperature_c, fuel_price_usd_per_l, and unemployment, in that order.
  • 3
    • Update the aggregation functions called by .agg(): include iqr and np.median in that order.