Python Automation Cookbook - Second Edition

By : Jaime Buelta

Python Automation Cookbook - Second Edition

By: Jaime Buelta

Overview of this book

In this updated and extended version of Python Automation Cookbook, each chapter now comprises the newest recipes and is revised to align with Python 3.8 and higher. The book includes three new chapters that focus on using Python for test automation, machine learning projects, and for working with messy data. This edition will enable you to develop a sharp understanding of the fundamentals required to automate business processes through real-world tasks, such as developing your first web scraping application, analyzing information to generate spreadsheet reports with graphs, and communicating with automatically generated emails. Once you grasp the basics, you will acquire the practical knowledge to create stunning graphs and charts using Matplotlib, generate rich graphics with relevant information, automate marketing campaigns, build machine learning projects, and execute debugging techniques. By the end of this book, you will be proficient in identifying monotonous tasks and resolving process inefficiencies to produce superior and reliable systems.

Preface

Who this book is for

What this book covers

To get the most out of this book

Get in touch

Let's Begin Our Automation Journey

Activating a virtual environment

Installing third-party packages

Creating strings with formatted values

Manipulating strings

Extracting data from structured strings

Using a third-party tool—parse

Introducing regular expressions

Going deeper into regular expressions

Adding command-line arguments

Free Chapter

Automating Tasks Made Easy

Preparing a task

Setting up a cron job

Capturing errors and problems

Sending email notifications

Building Your First Web Scraping Application

Downloading web pages

Interacting with forms

Using Selenium for advanced interaction

Accessing password-protected pages

Speeding up web scraping

Searching and Reading Local Files

Crawling and searching directories

Reading text files

Dealing with encodings

Reading CSV files

Reading log files

Reading file metadata

Reading images

Reading PDF files

Reading Word documents

Scanning documents for a keyword

Generating Fantastic Reports

Creating a simple report in plain text

Using templates for reports

Formatting text in Markdown

Writing a basic Word document

Styling a Word document

Generating structure in Word documents

Adding pictures to Word documents

Writing a simple PDF document

Structuring a PDF

Aggregating PDF reports

Watermarking and encrypting a PDF

Fun with Spreadsheets

Writing a CSV spreadsheet

Updating CSV files

Reading an Excel spreadsheet

Updating an Excel spreadsheet

Creating new sheets in an Excel spreadsheet

Creating charts in Excel

Working with cell formats in Excel

Creating a macro in LibreOffice

Cleaning and Processing Data

Preparing a CSV spreadsheet

Appending currency based on location

Standardizing the date format

Aggregating results

Process data in parallel

Process data with Pandas

Developing Stunning Graphs

Plotting a simple sales graph

Drawing stacked bars

Plotting pie charts

Displaying multiple lines

Drawing a scatter plot

Visualizing maps

Adding legends and annotations

Combining graphs

Saving charts

Dealing with Communication Channels

Working with email templates

Sending an individual email

Reading an email

Adding subscribers to an email newsletter

Sending notifications via email

Producing SMS messages

Receiving SMS

Creating a Telegram bot

Why Not Automate Your Marketing Campaign?

Introduction

Detecting opportunities

Creating personalized coupon codes

Sending a notification to a customer on their preferred channel

Preparing sales information

Generating a sales report

Machine Learning for Automation

Introduction

Analyzing images with Google Cloud Vision AI

Extracting text from images with Google Cloud Vision AI

Analyzing text with Google Cloud Natural Language

Creating your own custom machine learning model to classify text

Automatic Testing Routines

Introduction

Writing and executing test cases

Testing external code

Testing using dependency mocking

Testing using HTTP call mocking

Preparing testing scenarios

Running tests selectively

Debugging Techniques

Introduction

Learning Python interpreter basics

Debugging through logging

Debugging with breakpoints

Improving your debugging skills

Other Books You May Enjoy

Index

Customer Reviews

5 star

4 star

3 star

2 star

1 star

Plotting pie charts

Pie charts! A Business 101 favorite, and a common way of presenting percentages. We'll see in this recipe how to plot a pie chart, with different slices representing proportions.

Getting ready

We need to install matplotlib in our virtual environment using the following commands:

$ echo "matplotlib==3.2.1" >> requirements.txt
$ pip install -r requirements.txt

If you are using macOS, you may get an error like this: RuntimeError: Python is not installed as a framework. See the matplotlib documentation on how to fix it: https://matplotlib.org/faq/osx_framework.html.

How to do it...

Import matplotlib:
```
>>> import matplotlib.pyplot as plt
```

Prepare the data. This represents several lines of products:

>>> DATA = (
...     ('Common', 100),
...     ('Premium', 75),
...     ('Luxurious', 50),
...     ('Extravagant', 20),
... )

Python Automation Cookbook - Second Edition

By : Jaime Buelta

Python Automation Cookbook - Second Edition

By: Jaime Buelta

Overview of this book

Related Content you might be interested in

Current Title:

Python Automation Cookbook - Second Edition

Python Architecture Patterns

Crafting Test-Driven Software with Python

Automate it! - Recipes to upskill your business

Plotting pie charts

Getting ready

How to do it...