Category: Analytics
This shelf is the job, not a tool manual. You are here if someone expects a number, a chart, or a “what should we do,” and the spreadsheet is starting to argue with itself. The articles cover the question before the query, a metric with a written definition, a chart that answers something, data that is fit to ship, and the messy middle of pipelines and stewardship.
It is not the SQL category. SQL is how you ask a table. Analytics is what you are trying to decide, and whether the number is even the right one. It is not the AI category either. A model can draft the email about the metric. It does not pick the metric.
Where to start: Analytics foundations if you do not yet have a clear question. Metrics if the team is arguing about a definition. Charts if the picture is pretty and the decision is still fuzzy. The SQL series when you are ready to ask the table yourself. Learn groups these as a track so you do not have to guess an order from a flat list.
How to clean up missing values and wrong column types in pandas
Nulls, empty strings, and bad dtypes break joins and totals in quiet ways. Learn safe pandas casting with coerce, careful fill versus drop, and a symptom-to-fix table you…
Joins and merges in plain English
Learn how pandas merges map to SQL joins, when row counts explode, and how to check keys with validate and indicator. A customers-and-orders walkthrough keeps grain honest before…
How to summarize data with groupby in pandas
Learn pandas groupby as split-apply-combine, the same idea as SQL GROUP BY. Build sum, mean, count, and multi-metric aggregations, with a clear sales-by-region before and after table example.
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…
Pandas DataFrames explained: rows, columns, and column types
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…




