Downloads
The data the course runs on, the session notebooks, and the runnable copy of every handbook chapter.
Set up
| File | What it is | Link |
|---|---|---|
| .gitignore for your course repository | The list of things git should leave out of your commits: your .venv, marimo's session cache, Python's bytecode, and anything private. It is GitHub's Python template with one line added for macOS, .DS_Store. Copy it into the .gitignore in the root folder of your repository, the one that holds README.md, as in step 11 of Getting Started. The Python template GitHub Desktop offers is an older copy with no line for marimo's session cache. | |
| Your agent's rules | The course's rules for your agent. Save it as AGENTS.md in the root folder of your repository and commit it, and the agent in VS Code reads it with every request. Paste the same text into marimo's Custom Rules. The steps are in Your AI Tools and Babson Key. |
Projects
| File | What it is | Link |
|---|---|---|
| Mini Project 1 starter notebook | The notebook to build Mini Project 1 in, with its sections laid out. Save it in your course repository as projects/mp1/ followed by a name for what your tool does, such as loan-schedule.py, and open it with uv run marimo edit. What the project asks for is on its page, linked from the calendar. |
The warehouse
| File | What it is | Link |
|---|---|---|
| Northwind orders | 16,282 rows, one per order. The starting point for most of the term's SQL. Read it with DuckDB's read_parquet or polars' pl.read_parquet. | |
| Northwind order details | 609,283 rows, one per line item. Joining this to orders without first saying what one row of the result means is how a total silently grows. | |
| Northwind customers | 93 rows. Carries the region column whose blanks are the term's first real question about what a missing value means. | |
| Northwind products | 77 rows, with the supplier and category keys the joins use. |
The retail data
| File | What it is | Link |
|---|---|---|
| Online Retail | 541,909 rows, every transaction of a UK online giftware retailer between 1 December 2010 and 9 December 2011. What the Python chapters run on, because a real file is where the questions about types and missing values come from. Chen, D. (2015), UCI Machine Learning Repository, https://doi.org/10.24432/C5BW33, licensed CC BY 4.0. |
The TV show data
| File | What it is | Link |
|---|---|---|
| CS50's TV show database | The TV show database from the topic slides: shows.db, a SQLite file of 234,715 shows and 670,167 people, inside CS50's lecture 7 source code, a 32 MB zip. It is CS50's build of IMDb data, which IMDb allows for personal and non-commercial use only, so it is linked from CS50 and not copied here. DuckDB opens it with its sqlite extension: INSTALL sqlite; LOAD sqlite; ATTACH 'shows.db' AS tv (TYPE sqlite, READ_ONLY); USE tv; |
Session notebooks
| File | What it is | Link |
|---|---|---|
| 01 · Your first notebook | 01-first-notebook.py. Put it in your project's notebooks/ folder and open it with uv run marimo edit. | |
| 02 · Lists and records | 02-lists-and-records.py. Put it in your project's notebooks/ folder and open it with uv run marimo edit. | |
| 03 · Collections and APIs | 03-collections-and-apis.py. Put it in your project's notebooks/ folder and open it with uv run marimo edit. | |
| 04 · Functions and APIs | 04-functions-and-apis.py. Put it in your project's notebooks/ folder and open it with uv run marimo edit. | |
| 05 · From a CSV file to a dataframe | 05-csv-and-dataframes.py. Put it in your project's notebooks/ folder and open it with uv run marimo edit. | |
| 06 · Building and querying a database | 06-building-and-querying.py. Put it in your project's notebooks/ folder and open it with uv run marimo edit. |
Python handbook
| File | What it is | Link |
|---|---|---|
| 1. Essentials | 10 sections. The runnable copy: put it in your project and open it with uv run marimo edit. | |
| 2. Collections | 9 sections. The runnable copy: put it in your project and open it with uv run marimo edit. | |
| 3. Data | 11 sections. The runnable copy: put it in your project and open it with uv run marimo edit. | |
| 4. Agents and APIs | 9 sections. The runnable copy: put it in your project and open it with uv run marimo edit. |
SQL handbook
| File | What it is | Link |
|---|---|---|
| 1. What a Database Is | 5 sections. The runnable copy: put it in your project and open it with uv run marimo edit. | |
| 2. Asking One Table a Question | 11 sections. The runnable copy: put it in your project and open it with uv run marimo edit. | |
| 3. More Than One Table | 7 sections. The runnable copy: put it in your project and open it with uv run marimo edit. | |
| 4. Building and Loading | 5 sections. The runnable copy: put it in your project and open it with uv run marimo edit. |