Category: Analytics
Selecting, filtering, and sorting in pandas
Map SQL SELECT, WHERE, and ORDER BY onto clear pandas patterns you can debug at work. Select columns, filter with boolean masks, sort results, and keep method chains…
DataFrames as tables
A pandas DataFrame is just a table with rows, columns, and types you can inspect. Learn to load a CSV, check shape and dtypes, rename columns, and map…
Setup without tears
Set up Python for analytics without the folklore that scares people off. Create a virtual environment, install pandas with pip, and load a tiny CSV so your first…
Why Python for analytics (and when to stay in SQL or Sheets)
Python is optional for many analytics jobs, and that is a feature, not a failure. Learn when Sheets or SQL still win, when a notebook saves real hours,…
Your first table contract
One page that records grain, keys, ownership, columns, exclusions, and allowed use so multiplayer tables stay trustworthy.
