YAML
Converting YAML to a Markdown Table for Docs and READMEs
Generate a Markdown table from a YAML list in Python, escaping pipes, joining lists, handling blanks and keeping the table in sync with the YAML in CI.
6 min read
Tag
python
134 posts
YAML
Converting an Excel Sheet of Settings Into YAML Using Python
Read a key, value and type sheet with openpyxl, build nested YAML from dotted keys, and keep versions, dates and blanks from changing on the way.
7 min read
YAML
Converting a CSV Into a YAML List With Correct Types
Turn CSV rows into a YAML list of mappings in Python, keeping zip codes as text and giving integers, floats, booleans and empty cells the right types.
6 min read
YAML
Converting YAML to CSV for Review in a Spreadsheet
Flatten a YAML list of service records into a CSV a reviewer can sort and filter, handling nested keys, list values, missing fields and Excel encoding.
6 min read
JSON
Partial Updates and Patch Semantics in JSON APIs Done Right
Why a PUT drops fields, why dict.update clobbers nested objects, how absent differs from null in Pydantic, and how field-level SQL avoids lost updates.
7 min read
CSV
Loading CSV Files in Airflow With a Plain Python Task
Load a daily CSV in Airflow with one plain Python task instead of a chain of operators: idempotent by date, safely retried and testable outside Airflow.
7 min read
CSV
A Python Script That Loads a Daily CSV Into PostgreSQL
A complete psycopg 3 script that stages a daily CSV with COPY, merges it with an upsert, records a content hash, and is safe to run again after a failure.
8 min read
CSV
Detecting Encoded Payloads Hidden in CSV Fields Fast
A short Python scanner that flags base64 blobs, percent-encoded text, script tags, formula starts and oversized fields in a CSV before you import it.
6 min read
CSV
Hashing or Masking Columns in a CSV Safely Without Leaks
A plain SHA-256 of an email is reversible with a guess list. Use a keyed HMAC for tokens and partial masking for display, with a script that does both.
7 min read
YAML
Converting JSON to YAML Without Losing Types or Quotes
Convert JSON to YAML with a YAML library so strings like yes, 3.10 and 02134 keep their quotes, and see what string formatting does to the same data.
7 min read
CSV
Escaping Formula Characters in a CSV Export Safely
A small function that neutralizes formula triggers in CSV text cells, why negative numbers must be exempt, and a test table to keep the fix from regressing.
7 min read
YAML
Converting YAML to JSON in Python Without Date Errors
Convert YAML to JSON with PyYAML and json, and handle the cases that break it: dates, sets, integer keys, NaN, anchors, several documents and complex keys.
6 min read