Day 41 · pandas queries 50 min 40 XP

🔍Selecting, filtering and sorting

These are SELECT, WHERE and ORDER BY in pandas clothing. If you can write the SQL you already know how to think about this; today is just the new spelling.

What you'll learn

Select columns and rows with [], loc and iloc
Filter with boolean conditions, & and |
Sort with sort_values and keep the top N

A peek inside

Columns and rows

The rest of Day 41 is a Pro lesson

You're on the free Explorer plan — you get the intro and the video. Go Pro to open the full guided lesson (and all 30 days).

3 deep-dive lessons
A copy-paste worked example
3 hands-on practice tasks
Studio task: Translate three SQL queries to pandas
3-question quiz, up to 45 XP
4 quick-glance glossary cards
40 XP + streak tracking

Unlock everything — go Pro

Already Pro? Sign in