Handbook
Two reference books, one for Python and one for SQL, cut by concept rather than by week. Nothing here is assigned. Look something up when you need it, or read a chapter through.
Python
Glossary 60 terms Excel to Python
C · Data
Download 03-data.py
- 20Files and paths
- 21Parquet, CSV and JSON
- 22
try/except, andassert - 23Series and DataFrame
- 24Selecting, filtering, sorting
- 25A column of dates
- 26
.value_counts()and.group_by().agg() - 27Merging two tables
- 28Wide and long
- 29A chart with labeled axes
- 30pandas
- Chapter challenge
- 🤖 Ask your agent
- Chapter C checklist
SQL
Glossary 67 terms SQL dialects Excel to SQL
B · Asking One Table a Question
Download 02-asking-one-table.py
- 6
SELECTandFROM - 7
WHERE - 8
ORDER BYandLIMIT - 9
NULL, and why it is not zero - 10
DISTINCT, and what it hides - 11
CASE WHEN - 12Dates: truncating, differencing, grouping by month
- 13Aggregate functions
- 14
GROUP BY - 15
HAVING, againstWHERE - 16The order the clauses actually run in
- Chapter challenge
- 🤖 Ask your agent
- Chapter B checklist