<LEARN/>
← /paths/data

<project · beginner>

Explore a public dataset

Clean a CSV with pandas and tell a story with three charts.

Build explore a public dataset one manageable milestone at a time. Keep your decisions, tests and finished work together so your portfolio shows what you learned, not only the final result.

Build it step by step

  1. Choose a usable dataset

    Pick a public CSV with a clear licence, such as an open city transport dataset. Record its source, download date and three questions you want to answer.

  2. Inspect the raw data

    Create a Jupyter notebook with pandas. Check column types, missing values, duplicates and units before changing anything, keeping the raw CSV unchanged.

  3. Clean with a record

    Write repeatable cleaning functions and record why rows or values change. Do not fill missing values or remove outliers without explaining the effect.

  4. Tell the story

    Use Matplotlib or Seaborn to create three charts that answer your questions. Give axes units, use accessible colours and pair every chart with a short interpretation.

  5. Check the findings

    Restart the notebook and run all cells in order. Reconcile totals before and after cleaning and include limitations rather than implying correlation proves causation.

  6. Share your finished work

    Commit your source and a README explaining setup, decisions, tests and limitations. Remove secrets and personal data, credit dependencies and assets, then add the public repository or portfolio link and an optional working demo to LEARN Showcase. Hosting is optional; a clear repository or design case study is enough.

// done when

  • Raw data and licence are credited
  • Cleaning runs reproducibly
  • Three charts answer stated questions
  • Findings include data limitations
  • README includes setup, credits and limitations; shared links are safe and accessible

// stretch goals

  • Add an interactive chart
  • Compare a second time period

Finished? Show it off

Add your project to the LEARN showcase so other learners and employers can see it.

Sign in to add your finished project to the showcase.