Tutorial
Hands-on walkthroughs for SQL, Python, Excel and visualisation tools — every example is runnable, not a screenshot.
121 articles in Tutorial · Page 12 of 14
Market Basket Analysis in Python: Support, Confidence, and What to Do With Them
Build a market basket analysis in Python — basket matrix, co-occurrence, lift scores, and a rule-based recommender from transaction logs.
NumPy Foundations: 30 Questions That Build Array Intuition
Learn NumPy from zero — arrays vs lists, zeros, arange, reshape, broadcasting, and vectorised operations with 30 hands-on questions.
Pandas Advanced Masterclass: Merge, Rank, and Window Functions Like SQL
Advanced Pandas — set_index, merge joins, rank vs dense_rank, shift/lead-lag, and groupby window functions mirroring SQL.
Pandas Cheatsheet: The 7 Sections Every Analyst Memorises
The Pandas cheatsheet analysts actually use — inspect, select, filter, handle nulls, sort, groupby, and merge with one-liner patterns.
Pandas Fundamentals: 40 Questions to Go From List to DataFrame
Pandas fundamentals in 40 questions — Series, DataFrame, head, dtypes, loc vs iloc, filtering, sorting, and null handling.
Pandas Master Workbook: 50 GroupBy, Aggregate, and Merge Drills
50 Pandas drills on groupby, agg, pivot tables, and merges — the repetition that makes aggregation second nature.
Python Basics Workbook: Control Flow and Functions With 20 Drills
Master Python basics — if/elif/else, for/while loops, functions, and return values — with 20 bite-size drills and solutions.
Python Fundamentals Master: Strings, Regex, and Data Structures in 30 Questions
Complete Python fundamentals — slicing, f-strings, regex, lists, dicts, and file handling — 30 questions with explained solutions.
Python String Assignments: 5 Real-World Slicing and Formatting Drills
Practice Python strings on real tasks — email slicer, reverser, cleaner, vowel counter, and f-string formatter with solutions.