Introduction to Pivot Tables

Pivot tables are powerful tools that allow us to summarize, analyze, and explore data in different ways. They are commonly used in data analysis for generating insights from data by arranging, sorting, and aggregating it.

In this lesson, we will learn how to create and use pivot tables in Pandas. By the end of this lesson, you will understand the basics of pivot tables, how to create them, and how they can help you extract valuable insights from your data.

A pivot table allows us to summarize data by grouping it in a way that makes it easier to extract meaningful insights. Think of it like organizing toys in a toy store. Instead of having all toys mixed up, you sort them by category and then further by different attributes. Pivot tables help us do something similar with our data.

The Pandas library provides a function called pivot_table() that makes creating pivot tables in Python straightforward. One reason pivot tables are so useful is that they allow us to easily perform aggregate functions like mean, sum, and count on data.

Here are the important parameters of the pivot_table() function:

• index: The column(s) to group by, like aisles in a store.
• columns: The column whose distinct values will form the columns of the pivot table.
• values: The columns containing the data you want to aggregate, like toy prices.
• aggfunc: The function used to aggregate the data (e.g., mean or sum).

Let's start by creating a simple pivot table. Suppose you have data about different products, and you want to see the average price of each product category:

import pandas as pd

# Sample DataFrame
data = {
    'Product': ['Toy', 'Toy', 'Book', 'Book', 'Electronic'],
    'Category': ['A', 'B', 'A', 'B', 'A'],
    'Price': [10, 15, 7, 12, 100]
}
df = pd.DataFrame(data)

# Create a pivot table
pivot_table = df.pivot_table(index='Product', values='Price', aggfunc='mean')
print(pivot_table)

The output will be:

             Price
Product            
Book            9.5
Electronic    100.0
Toy            12.5

This code groups the data by the Product column and calculates the average price for each product. Running this shows the average price for Toy, Book, and Electronic.