Image by Pexels from Pixabay

How to use SUM, COUNT, AVERAGE, MAX and MIN with Pandas and Python in a Jupyter Notebook

Documentation for several common Excel functions — SUM, COUNT, AVERAGE, MAX, and MIN — with Pandas, Python and Jupyter Notebook

It’s difficult to imagine any sort of data analysis without these basic, core functions of Excel: adding, counting, taking an average, finding the max and min…

In this tutorial, I’ll show you exactly how to use these common Excel functions on your Pandas DataFrame. And because we’ll need a dataset before we can do anything, we’ll also quickly go over the basics of pulling data from a public API.

Let’s get started.

Table of Contents

1. Set up notebook
2. Import data from public API
3. Filtering
4. SUM
5. COUNT
6. SHAPE
7. AVERAGE (MEAN)
8. MAX & MIN

Step 1: Set up notebook

First, let’s get a new notebook open and import pandas:

import pandas as pd