Pandas on LakeBench

Learn Pandas for data analysis

Pandas is how Python works with tables. The track shows how to select and filter rows, group and summarise, merge tables and clean messy columns, using small datasets you can see in full.

  • 20

    lessons

  • 8

    free lessons

  • 30

    Pandas sheet problems

What you will be able to do

After the sheet you can load a table, answer questions about it with a few lines, and clean the typical problems: missing values, duplicates and wrong types.

Learn it in order

Pandas: Data Analysis with Python has 5 modules. 8 lessons are free.

  1. Module 1

    Getting Started with Pandas

    3 lessons

  2. Module 2

    Cleaning, filtering and the pandas way

    4 lessons

  3. Module 3

    Transforms & shape

    6 lessons

  4. Module 4

    Scaling Up

    3 lessons

  5. Module 5

    Production Pandas

    4 lessons

See the full Pandas: Data Analysis with Python track

Practice by topic

Pandas 30 lists 30 problems in a fixed order, 17 of them free. Work through one topic at a time.

  • Read and inspect data3
  • Missing data3
  • Clean and cast columns8
  • groupby: aggregate and transform6
  • Merge tables4
  • Keep the latest row per key3
  • Pivot and melt3

More for Pandas

Questions

Should I learn Python before Pandas?
A little. If you can write a loop and use a list and a dictionary, you are ready. The Python track covers those in its first lessons.
Is Pandas the same as SQL?
They answer the same questions in different ways. Many analyst jobs use both, so the lessons show the SQL idea next to the Pandas one where it helps.