
Python Pandas Tutorial: A Complete Guide from Basics to Advanced
Learn Python Pandas from Series and DataFrames to groupby, merge, time series, Copy-on-Write and performance, with tested pandas 3 examples and 10 projects.
Writing
Practical notes on Python, Django, APIs, and backend engineering, from building production systems.
Follow on Medium
Learn Python Pandas from Series and DataFrames to groupby, merge, time series, Copy-on-Write and performance, with tested pandas 3 examples and 10 projects.

How Single Sign-On works, SAML vs OAuth 2.0 vs OpenID Connect, and a tested Keycloak and Django SSO setup with two apps, PKCE, logout and security tips.

Build fast bulk CSV import/export pipelines in Django: ZIP handling, Celery background jobs, streaming, chunked bulk upserts, validation and retries.

A practical guide to Python testing and code quality: pytest, fixtures, mocking, coverage, Ruff, Black, mypy, pre-commit hooks and GitHub Actions CI.

Learn Redis with real examples: data types, essential Redis commands, caching with Python and Django, persistence, eviction, use cases and security tips.

Learn the Go programming language: key features, fundamentals with working code, goroutines, testing and a Go REST API with Gin. Tested on Go 1.27.

PostgreSQL vs MySQL vs SQLite, Django ORM CRUD, database design, indexing and query optimization, with N+1 fixes and benchmarks measured on 1M rows.

28 essential AWS services explained with simple examples, four beginner architectures, the AWS CLI, key cloud concepts and an AWS learning roadmap.

Take a Python app from 1.15 GB to 124 MB with slim base images, .dockerignore, cache mounts and a non-root user. Measured results and a Docker cheat sheet.

Install FastAPI, build and run your first Python API, add request validation, and build a CRUD to-do API. Includes a comparison with Django REST Framework.

Commits, branching, merge vs rebase, undoing mistakes, hotfixes and releases, git bisect and secret-blocking hooks, plus a Git cheat sheet.

When to use threads, asyncio or processes in a Python backend, with measured benchmarks on regular and free-threaded Python 3.14 and Django guidance.

Load modules only when your code needs them: practical patterns, a measured startup benchmark, Django guidance and the lazy import syntax in Python 3.15.

How to find slow queries in Django, fix them with the ORM, and keep a project fast when tables grow past millions of rows.

How APIs communicate, how they know who is calling, how to design clean REST endpoints, and how to keep them secure.

Learn how Django processes every request and response, and why middleware is one of the most powerful features in Django.