Recently Published
SQL Window Functions: Stock Price Averages
Year-to-date and six-day moving averages of Apple, Microsoft and Amazon closing prices, calculated with SQL window functions and loaded into R.
Global Baseline Estimate Recommender
A Global Baseline Estimate movie recommender in R, checked against the course spreadsheet and applied to my Week 2 movie ratings.
Evaluating Classification Model Performance
Null error rate, confusion matrices, and accuracy, precision, recall and F1 at thresholds 0.2, 0.5 and 0.8 for a penguin sex classifier, with use cases for each threshold.
SQL and R: Movie Ratings
Six friends rate six 2025 movies: a normalized SQLite database loaded into R, with a tested strategy for missing ratings and a check on whether standardizing ratings helps.
Assignment 1 — Loading and Transforming English Premier League Match Data
Loading 25 seasons of EPL match data into R, selecting and renaming columns, decoding the full-time result target variable, and checking a COVID-era home-advantage study against the cleaned data.