Skip to Content
Learn
Aggregates in Pandas
Calculating Column Statistics

In the previous lesson, you learned how to perform operations on each value in a column using apply.

In this exercise, you will learn how to combine all of the values from a column for a single calculation.

Some examples of this type of calculation include:

  • The DataFrame customers contains the names and ages of all of your customers. You want to find the median age:
    print(customers.age) >> [23, 25, 31, 35, 35, 46, 62] print(customers.age.median()) >> 35
  • The DataFrame shipments contains address information for all shipments that you’ve sent out in the past year. You want to know how many different states you have shipped to (and how many shipments went to the same state).
    print(shipments.state) >> ['CA', 'CA', 'CA', 'CA', 'NY', 'NY', 'NJ', 'NJ', 'NJ', 'NJ', 'NJ', 'NJ', 'NJ'] print(shipments.state.nunique()) >> 3
  • The DataFrame inventory contains a list of types of t-shirts that your company makes. You want a list of the colors that your shirts come in.
    print(inventory.color) >> ['blue', 'blue', 'blue', 'blue', 'blue', 'green', 'green', 'orange', 'orange', 'orange'] print(inventory.color.unique()) >> ['blue', 'green', 'orange']

The general syntax for these calculations is:

df.column_name.command()

The following table summarizes some common commands:

Command Description
mean Average of all values in column
std Standard deviation
median Median
max Maximum value in column
min Minimum value in column
count Number of values in column
nunique Number of unique values in column
unique List of unique values in column

Instructions

1.

Once more, we’ll revisit our orders from ShoeFly.com. Our new batch of orders is in the DataFrame orders. Examine the first 10 rows using the following code:

print(orders.head(10))
2.

Our finance department wants to know the price of the most expensive pair of shoes purchased. Save your answer to the variable most_expensive.

3.

Our fashion department wants to know how many different colors of shoes we are selling. Save your answer to the variable num_colors.

Folder Icon

Sign up to start coding

Already have an account?