Blog
Short notes on what I'm learning in data science — Python, Pandas, SQL, and more.
- 13 min read
Adelaide Housing Pulse, Part 1: Wrangling 11 Years of SA Government Housing Data
Starting a real flagship project on Adelaide house prices: sourcing 46 quarterly files from South Australia's open data API, fixing several genuine data bugs, and finding which suburbs actually grew fastest since 2015, explained so both engineers and non-technical readers can follow it.
- pandas
- data-cleaning
- python
- adelaide-housing-pulse
- 6 min read
Handling Missing Data in Pandas
A real walkthrough of missing data on the Palmer Penguins dataset — finding it, understanding why it's missing, and deciding whether to drop or impute.
- pandas
- data-cleaning
- python
- 3 min read
Using Pandas GroupBy to Compare Tipping Behaviour
A quick walkthrough of groupby aggregations on the Tips dataset — comparing average tips between smokers and non-smokers.
- pandas
- python
- data-analysis
- 6 min read
Exploratory Analysis of the Tips Dataset
A walkthrough of my first end-to-end notebook — loading data, checking quality, visualising patterns, and comparing groups.
- pandas
- seaborn
- eda
- python
- 6 min read
Setting Up a Python Environment for Data Science
A practical guide to installing Python, managing packages, and preparing Jupyter before your first dataset — Windows, macOS, and Linux.
- python
- setup
- jupyter