Lib
#python
7entries tagged “python”.
Case Conventions in Python, JavaScript and SQL Server
What snake_case, camelCase, PascalCase and kebab-case actually look like, then where each language and SQL Server expects them — variables, functions, classes, constants, files and identifiers.
Exploratory Data Analysis in Python with marimo
A working cheat sheet for EDA in Python — why marimo over Jupyter, running it ephemerally with uvx, reactive notebook basics, and the core exploration toolkit.
OLAP Design with DuckDB, Parquet and Polars
Dimensional modeling for an analytical workload, why DuckDB rewards a different schema shape than a transactional database, where Parquet fits as the storage layer, and how to wire it all together in a Python project alongside Polars.
MkDocs Material Setup
Setting up MkDocs with the Material theme for a Python project — config, plugins, markdown extensions, and deployment — plus the move to Zensical.
Polars: Reading & Exploring Data
A working cheat sheet for Polars — reading Parquet files and getting a first look at a DataFrame: shape, schema, nulls, and unique values.
Python uv Command Reference
A working cheat sheet for uv — Python packaging, venvs, and project management — grouped by task.
Modern Python Project Setup with uv
A walkthrough for scaffolding a new Python project with uv — layout, pyproject.toml, dependency groups, linting, testing, and locking.