10.4 Pandas

Pandas is a Python library for working with tabular data — data arranged in rows and columns, like a spreadsheet. Its main structure is the DataFrame, which lets you load, filter, sort, group, and clean data with just a few lines of code.

Pandas is a key step in a data pipeline: raw data comes in, gets cleaned and reshaped, then flows to analysis or a model.

Imagine a CSV file of monthly sales for a shop in Mercato. With Pandas you could load the file, filter only the rows for one product, and calculate the total and average sales — all in a few commands instead of doing it by hand.

Scenario

You receive a CSV of survey responses with some blank cells and duplicate rows. What should you do first with Pandas?

Check your understanding

1/4 · 40 XP

Name the main Pandas data structure.

The main two-dimensional table structure in Pandas is called a ___.