Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Challenge | Aggregate Functions
Introduction to pandas [track]
course content

Course Content

Introduction to pandas [track]

Introduction to pandas [track]

1. Basics
What is pandas?SeriesIndexes and ValuesChallengeDataFramesIndexes and ColumnsChallenge
2. Reading and Exploring Data
Reading CSV FilesReading XLS/XLSX FilesExploring Data [1/3]ChallengeExploring Data [2/3]Exploring Data [3/3]Challenge
3. Accessing DataFrame Values
Accessing Specific ColumnsChallengeAccessing Specific RowsChallengeAccessing Rows and ColumnsAccessing using .loc[] [1/3]Accessing using .loc[] [2/3]Accessing using .loc[] [3/3]
4. Aggregate Functions
Number of ObservationsUnique ObservationsCounting ValuesChallengeSum and ProductMean and MedianChallengeMinimum and Maximum

Challenge

Task

You continue working with the DataFrame df with information on used cars.

  1. Get the mean engine size ('engineSize' column) of Petrol ('fuelType' column) cars.
  2. Get the median mileage ('mileage' column) of ' A3' (pay attention, there is a space in the beginning, it's important!) model ('model' column) cars.

Task

You continue working with the DataFrame df with information on used cars.

  1. Get the mean engine size ('engineSize' column) of Petrol ('fuelType' column) cars.
  2. Get the median mileage ('mileage' column) of ' A3' (pay attention, there is a space in the beginning, it's important!) model ('model' column) cars.

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Section 4. Chapter 7
toggle bottom row

Challenge

Task

You continue working with the DataFrame df with information on used cars.

  1. Get the mean engine size ('engineSize' column) of Petrol ('fuelType' column) cars.
  2. Get the median mileage ('mileage' column) of ' A3' (pay attention, there is a space in the beginning, it's important!) model ('model' column) cars.

Task

You continue working with the DataFrame df with information on used cars.

  1. Get the mean engine size ('engineSize' column) of Petrol ('fuelType' column) cars.
  2. Get the median mileage ('mileage' column) of ' A3' (pay attention, there is a space in the beginning, it's important!) model ('model' column) cars.

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Section 4. Chapter 7
toggle bottom row

Challenge

Task

You continue working with the DataFrame df with information on used cars.

  1. Get the mean engine size ('engineSize' column) of Petrol ('fuelType' column) cars.
  2. Get the median mileage ('mileage' column) of ' A3' (pay attention, there is a space in the beginning, it's important!) model ('model' column) cars.

Task

You continue working with the DataFrame df with information on used cars.

  1. Get the mean engine size ('engineSize' column) of Petrol ('fuelType' column) cars.
  2. Get the median mileage ('mileage' column) of ' A3' (pay attention, there is a space in the beginning, it's important!) model ('model' column) cars.

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Task

You continue working with the DataFrame df with information on used cars.

  1. Get the mean engine size ('engineSize' column) of Petrol ('fuelType' column) cars.
  2. Get the median mileage ('mileage' column) of ' A3' (pay attention, there is a space in the beginning, it's important!) model ('model' column) cars.

Switch to desktop for real-world practiceContinue from where you are using one of the options below
Section 4. Chapter 7
Switch to desktop for real-world practiceContinue from where you are using one of the options below
We're sorry to hear that something went wrong. What happened?
some-alt