Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Mean and Median | 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

bookMean and Median

pandas also provides calculations of mean values. To calculate an arithmetic mean (total sum of values/number of values) apply the .mean() method.

What is a median? Assume you sort values in ascending order. Then the middle value of new series is called median. This metric is better in terms of resistance to outliers. To get the median value apply the .median() method. For instance, we can get the average and median prices for all cars with Semi-Auto gear box.


              
123456789

            
# Importing library
import pandas as pd

# Reading csv file
df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/67798cef-5e7c-4fbc-af7d-ae96b4443c0a/audi.csv')
# Mean price
print(df.loc[df.transmission == 'Semi-Auto', 'price'].mean())
# Median price
print(df.loc[df.transmission == 'Semi-Auto', 'price'].median())
copy

Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 4. Chapter 6
some-alt