Search⌘ K
Home
Courses
Effective Data Manipulation with pandas

Reshaping by Pivoting and Grouping

Explore how to reshape data in pandas by applying pivot_table, groupby, and pd.crosstab techniques. Understand each method’s role to calculate averages and summarize data by categories, enabling you to manipulate DataFrames effectively for analysis.

We'll cover the following...

We have multiple syntaxes to creat pivot tables in pandas. One of these uses the pivot_table method, another common one leverages the groupby method, and we can also represent some of these operations with the pd.crosstab function.

Python 3.8
print(jb2)

A basic example

When our boss asks us to get numbers “by X column,” that should be a hint to pivot (or group) our data. Assume the boss asked, “What is the average age by country for each employment status?” This is like one of those ...