Posts

Browse Python, learning, engineering & experiments.

2025-12-04

Build a Universal ETL Toolkit in Python in Under 100 Lines

Build a tiny, reusable ETL toolkit in pure Python: one pipeline, swappable steps, and a CSV-to-CSV demo you can adapt .....

Fields: Python, Data Engineering
Dorian Sotpyrc
2025-12-03

Building a Custom QR Generator Tool with Python in Less Than 5 Minutes

Learn how to build a tiny Python QR generator script from scratch, add a centre logo safely, or skip straight to a .....

Fields: Python, Automation
Dorian Sotpyrc
2025-12-03

The 5-Minute Rule for Building Technical Projects That Actually Ship

Use a simple 5-minute rule to reduce friction, start tiny prototypes quickly, and actually ship more technical projects .....

Fields: Productivity, Engineering, Python
Dorian Sotpyrc
2025-12-02

The Great Print: What the Data Shows About Money Printing in the West

A data-driven look at how money supply exploded during Covid in the US, Europe, the UK, Australia and Canada, how it .....

Fields: Money & Banking, Macroeconomics
Dorian Sotpyrc
2025-12-01

Where does money come from?

A clear, research-based guide to how modern economies create money through central banks, commercial banks and .....

Fields: Money & Banking, Macroeconomics
Dorain Sotpyrc
2025-12-01

Introduction to Null Hypothesis Testing with Python

Learn how to frame a null hypothesis, run t-tests in Python with SciPy on real Iris data, and correctly interpret .....

Fields: Statistics, Python
Dorian Sotpyrc
2025-12-01

Excel vs Database: When to Make the Switch

Learn how to tell when your growing spreadsheets become a risk, and how to decide if a proper database is the right .....

Fields: Data Management, Business Analytics
Dorian Sotpyrc
2025-12-01

Migrating an Excel Spreadsheet into a Fully Fledged Operational Database with Python

Learn how to migrate a multi-sheet Excel workbook into a relational database using a config-driven Python pipeline with .....

Fields: Databases, Python
Dorian Sotpyrc