Data Tools · Module 2

pandas7 lessons and their Study toolkit.

Watch each lesson, answer its quiz, then do its practice. After the last lesson: the module quiz, the project, and the interview questions.

7of 7 lessons ready
39quiz questions
0key terms
4self-checking notebooks

The lessonsin the order to take them.

7 lessons ready to study
  1. 2.1Meet pandasSay what a DataFrame is and why tabular data gets its own library, by loading one real file and asking it a question. Open
  2. 2.2Series and DataFramesHold a table with named columns and an index. Open
  3. 2.3Selecting and FilteringGet the rows and columns you need. Open
  4. 2.4Cleaning DataFix types, missing values and duplicates. Open
  5. 2.5groupby and AggregationSplit, apply, combine: statistics per group. Open
  6. 2.6Merging, Joining and ReshapingCombine tables and change their shape. Open
  7. 2.7Dates and Time Series in pandasParse dates and resample time series. Open

Module quiz11 questions across it all.

Take it after the last lesson. Your first pick on each question is the one that counts.

Practicebuild it without a template.

Stated as a problem, with no step-by-step instructions. Working out the steps is the point.

Notebooksthat check your answers.

Open them in Google Colab. Each answer is checked as you go: correct, wrong with the expected value, or not answered yet.

  • Tables and selectionLessons 2.1 and 2.2 and 2.3 Courses plan
  • Cleaning and groupsLessons 2.4 and 2.5 Courses plan
  • Joins and datesLessons 2.6 and 2.7 Courses plan
  • Repair and reportThe module project, with checks Courses plan

Common mistakesacross the whole module.

What you see when it goes wrong, why it happens, and the fix.

Referencefor revising and for interviews.

The cheat sheet is one page of the module’s terms, rules and gotchas. The interview questions come with model answers.