All courses

Pandas, from CSV to a grouped report

Inspect a small dataset, handle missing values and build a summary whose counts and totals can be checked against the original rows.

Learning objectives

Load a CSV and inspect columns and data types.
Distinguish missing values from zero and row counts from valid counts.
Group, aggregate and reconcile results.

Syllabus

  1. Read a CSV and inspect what was loaded (1)
  2. Loading and inspecting data with pandas (1)
  3. Group, count and reconcile totals (1)
  4. Grouping and aggregating records (1)
Sign in