Python Automation Cookbook: 75 Python automation ideas for web scraping, data wrangling, and processing Excel, reports, emails, and more, 2nd Edition: ... and Excel, report, and email processing - Softcover

Jaime Buelta

Softcover

ISBN 10: 1800207085 ISBN 13: 9781800207080

Publisher: Packt Publishing, 2020

Synopsis

Get a firm grip on the core processes including browser automation, web scraping, Word, Excel, and GUI automation with Python 3.8 and higher

Key Features

• Automate integral business processes such as report generation, email marketing, and lead generation
• Explore automated code testing and Python's growth in data science and AI automation in three new chapters
• Understand techniques to extract information and generate appealing graphs, and reports with Matplotlib

Book Description

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.

What you will learn

• Learn data wrangling with Python and Pandas for your data science and AI projects
• Automate tasks such as text classification, email filtering, and web scraping with Python
• Use Matplotlib to generate a variety of stunning graphs, charts, and maps
• Automate a range of report generation tasks, from sending SMS and email campaigns to creating templates, adding images in Word, and even encrypting PDFs
• Master web scraping and web crawling of popular file formats and directories with tools like Beautiful Soup
• Build cool projects such as a Telegram bot for your marketing campaign, a reader from a news RSS feed, and a machine learning model to classify emails to the correct department based on their content
• Create fire-and-forget automation tasks by writing cron jobs, log files, and regexes with Python scripting

Who this book is for

Python Automation Cookbook - Second Edition is for developers, data enthusiasts or anyone who wants to automate monotonous manual tasks related to business processes such as finance, sales, and HR, among others. Working knowledge of Python is all you need to get started with this book.

Table of Contents

1. Let's Begin Our Automation Journey
2. Automating Tasks Made Easy
3. Building Your First Web Scraping Application
4. Searching and Reading Local Files
5. Generating Fantastic Reports
6. Fun with Spreadsheets
7. Cleaning and Processing Data
8. Developing Stunning Graphs
9. Dealing with Communication Channels
10. Why Not Automate Your Marketing Campaign?
11. Machine Learning for Automation
12. Automatic Testing Routines
13. Debugging Techniques

About this title

About the Author

Jaime Buelta is a full-time Python developer since 2010 and a regular speaker at PyCon Ireland. He has been a professional programmer for over two decades with a rich exposure to a lot of different technologies throughout his career. He has developed software for a variety of fields and industries, including aerospace, networking and communications, industrial SCADA systems, video game online services, and finance services.

Edition details

• Publisher: Packt Publishing
• Publication date: 2020
• Language: English
• ISBN 10: 1800207085
• ISBN 13: 9781800207080
• Binding: Paperback
• Edition number: 2
• Number of pages: 526