Week 6: Data Preparation#
Status: Draft scaffold.
Use this week for cleaning, reshaping, validating, and preparing data for analysis.
Topics#
- Spreadsheet cleaning
- Shell and editor workflows
- SQL transformations
- DuckDB workflows
- JSON parsing
- Data validation and quality checks
Learning Goals#
- Clean and reshape data from common messy formats.
- Use SQL and DuckDB for repeatable transformations.
- Validate assumptions before analysis.
- Prepare datasets for downstream analysis, modeling, or visualization.
Content Checklist#
- Final lesson sequence
- Practice datasets
- Validation examples
- Assessment link