Python Automation Cookbook, Third Edition

Put Python to Work on the Repetitive Stuff 💻

Python Automation Cookbook, Third Edition is a hands-on collection of recipes for developers who would rather spend their time on interesting problems than on repetitive file wrangling, report generation, and data cleanup. The book takes a practical, task-first approach: each recipe targets a real automation problem and shows how Python can solve it with maintainable code.

This third edition, published by Packt in 2026, has been updated with more than 100 recipes and adds new material on scalable workflows, MCP integrations, and AI-powered automation. It also reflects current Python tooling, including managing multiple Python versions and virtual environments with uv.

What’s New in the Third Edition 🧠

The update is not a light refresh. It speaks to how automation work has changed:

• MCP integrations — connecting Python workflows to modern AI tooling.
• AI-powered automation — practical recipes for workflows that combine scripts and AI services.
• Scalable workflows — techniques for automation that can grow beyond a single script.
• Modern environment management — working with multiple Python versions and virtual environments through uv.
• Updated web automation — advanced interaction with Playwright and other browser-based tasks.

From Core Python Skills to Useful Command-Line Tools ⚙️

The opening chapters build the foundation. You will find recipes for creating formatted strings, extracting data from structured strings, using the parse library, and working with regular expressions at increasing depth. Command-line arguments, error handling, and email notifications are covered with an eye toward scripts you can actually schedule and trust.

Scrape, Read, and Report Without Reinventing the Wheel

Web scraping receives substantial attention: interacting with forms, handling password-protected pages with basic authentication, working with browser cookies, using Playwright for advanced interactions, and speeding up scraping when the job gets large. The file and reporting chapters turn to the local side of automation—crawling directories, dealing with encodings, reading Word documents, and scanning documents for keywords.

Report generation is treated as a first-class automation task. Recipes cover plain-text reports, templates, Markdown formatting, Word document creation and styling, adding pictures, building simple PDFs, aggregating PDF reports, and watermarking or encrypting PDFs.

Spreadsheets, Data Cleaning, and Graphs 📊

Spreadsheet automation gets a full chapter of its own, with recipes for reading and updating Excel files, creating new sheets, building charts, and working with cell formats. From there, the book moves into cleaning and processing data: preparing CSV files, appending currency based on location, standardizing date formats, transforming and validating JSON, processing data in parallel, and using Pandas for larger data tasks. The final chapters extend this into developing graphs, including sales graphs and multi-line plots.

Who This Cookbook Is For

This is a strong fit for Python developers, DevOps and systems professionals, data analysts, and technical hobbyists who already know some Python and want a reference they can dip into when a task needs automating. The recipe format makes it useful as a cover-to-cover read, a project companion, or a shelf reference for the next time someone asks, “Can this be automated?”

Why a Recipe Collection Works for Automation 🐍

Automation problems rarely arrive in a tidy sequence. A recipe collection lets you start with the problem in front of you, borrow the approach, and adapt it to your own files, APIs, reports, or workflows. Python Automation Cookbook, Third Edition is built for that kind of practical, just-in-time learning—for cleaning a spreadsheet, scraping a site, generating a report, or designing a workflow that includes AI.