All Sheets
Practical cheat sheets to help you learn and build faster.
OPTICS Clustering – Visual Guide with Python
A 15-page visual guide to OPTICS density-based clustering. Learn core distance, reachability plots, cluster extraction, parameter tuning, and how OPTICS compares with DBSCAN, k-means, and HDBSCAN through worked examples, computed charts, and Python code.
Which Chart Should I Use? – Data Visualization Guide
A 23-page visual guide to choosing the right chart for your data. Learn when to use bar charts, line charts, histograms, scatter plots, heatmaps, box plots, and more, with decision flowcharts, practical examples, and Python code.
Python for Excel Users – Excel to Pandas Visual Guide
A 16-page visual guide that translates familiar Excel formulas, functions, filters, lookups, PivotTables, charts, and automation workflows into Python and pandas—with 110+ Excel-to-pandas translations and practical examples.
Pandas Complete Reference — Visual Data Analysis Guide
A visual, example-driven Pandas reference covering DataFrames, data cleaning, filtering, transformation, GroupBy, reshaping, merging, time series, statistics, performance, and Pandas 3.0.