Step 1 of 9
Start here: which region really sold the most?
This pandas for beginners lesson starts with a question every spreadsheet user meets: which region sold the most? In Excel you would filter, build a pivot table and sort; in Python, pandas answers it in a few short lines that work the same on twelve rows or a hundred thousand.
You just watched a table of orders become an answer: a filter dimmed the small orders, each region's revenue stacked into one bar, and the bars sorted themselves. By the end of this lesson you will write the pandas code that does exactly that.
What you'll do
- Load a CSV of sales orders as a DataFrame and read it like a spreadsheet.
- Filter rows, group and sum them, and sort the result.
- Chart the answer with one line of code.
- Practise with exercises you check as you go.
By the end you can
- Answer "how much, by what, and which is biggest" questions about a table with pandas.
- Turn an Excel filter, SUMIFS or pivot table into pandas code, and read what pandas prints.
What you need: a browser. A little Python helps (variables, lists, calling a function); nothing needs installing.