Data Literacy Foundations
Learn to read charts critically, clean a real dataset, and write up what it shows, with free tools and open data.
Clean a small tabular dataset
I can take a raw spreadsheet or CSV file with missing values, inconsistent formats, and duplicate rows, and produce a tidy dataset together with a written log of every change I made.
- Domain
- Data Literacy
- Level
- intermediate
- Status
- draft · v0.1.0
- Also called
- Data cleaning, Data wrangling
- License
- CC BY-SA 4.0
Learn first
- Read and interpret a chart foundation
Learn it
Scope
Datasets of up to a few thousand rows in a spreadsheet or CSV file. Handling missing values, inconsistent dates and text, duplicates, and obvious outliers, using a spreadsheet or a free scripting tool. The change log is as important as the cleaned file.
Resources
| Resource | Kind | Cost | Provider |
|---|---|---|---|
| Kaggle Learn, Data Cleaning | interactive | free | Kaggle |
| Google Sheets | tool | free |
Courses that include it
Prove it
Evidence of mastery
- Submits the raw file, the cleaned file, and a change log that a reviewer can use to reproduce the cleaning.
- Every removed or altered row is accounted for in the log.
Assessments that measure it
Dataset Cleaning Project
A project in which the learner cleans a real dataset, documents every change, and writes a short findings note.
Credentials that include it
Data Literacy Foundations
The holder can read charts critically, clean a small dataset with a reproducible change log, and summarize and communicate findings to a non-expert.
What comes next
- Summarize a dataset and communicate findings intermediate