Skip to course content
Free course

Data Analysis and Visualization with Python / Module 5

Module 5 activity

Module 5 Activity: Clean a Messy Course Table

Estimated active time: 90 minutes

Task

Clean a fictional messy course records table and document every important decision.

Steps

  1. Load the messy dataset.
  2. Copy the raw DataFrame before cleaning.
  3. Count missing values.
  4. Find exact duplicates.
  5. Check numeric ranges.
  6. Convert at least one numeric column.
  7. Parse at least one date column.
  8. Standardize at least one text or category column.
  9. Investigate at least one outlier.
  10. Complete the cleaning log.
  11. Save a cleaned output file.
  12. Update the data dictionary.

Deliverable

  • Cleaning notebook or worksheet.
  • Cleaning log.
  • Updated data dictionary.
  • Final row and column counts.

Quality bar

The activity is ready when every cleaning action has a reason and a follow-up check.