Blog
Short notes on what I'm learning in data science — Python, Pandas, SQL, and more.
- 9 min read
Woolworths: Chase Market Share or Fix the Margin? What Five Years of Public Data Say
Australians spent 17% more at supermarkets between FY2021 and FY2025, but once you take out inflation they actually bought less. Using public Woolworths and ABS data in R, this post works out whether Woolworths gains more from winning market share or from fixing its profit margin, then checks the answer against the FY2026 results.
- r
- ggplot2
- data-analysis
- inflation
- business-case
- 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