Agrawal Ambuj. Enterprise Automation with Python: Automate Excel, Web, Documents, Emails, and Various Workloads with Easy-to-code Python Scripts

BPB Online, 2022. — 194 p. — ISBN 978-93-55511-379, 935551137XWritten by Zappy AI's founder, this book gives real-world examples of how readers can implement automation in their businesses and business-as-usual tasks. Through a series of real-world examples and live demonstrations, this book shows how to automate various tasks using Python scripts.
This book gives solutions to everyday automation needs and repetitive tasks at work every day. Readers will be able to discover the most typical business process that can be automated and write simple Python scripts to turn them automated. This book will teach you how to create, read, change, and extract data from Excel documents using Python programming. Readers can extract data from websites, PDF documents, Gmail, Outlook, and WhatsApp chats. Text extraction from photos and scanned documents is also smartly accomplished in this book.
The final section will examine techniques for extending your Python scripting skills and constructing complicated end-to-end process automation.
Throughout the book, readers will be utterly captivated by how to automate their tedious tasks and enhance their organisations' productivity by 500 percent.This book is divided into 11 chapters. The details are listed below.
In Chapter 1, you will be introduced to the installation steps and setting up the development environment for Python. We will also cover the
installation of Python packages and libraries required for building automations.
In Chapter 2, you will be introduced to the installation steps and setting up the development environment for Python. We will also cover the
installation of Python packages and libraries required for building automations.
In Chapter 3, we will discuss the mindset needed to be successful in implementation of automations within your organizations. We will go
through the process of identifying and prioritizing automation opportunities.
We will also discuss the ways to share the developed automations with the wider organization once they are created.
In Chapter 4, we will discuss ways to automate Excel workflows including creating, writing, and updating the Excel documents. We will also discuss the data manipulation techniques with Excel and CSV documents.
In Chapter 5, we will go through automation for websites and web-based tasks. We will look at how to download data from websites and automate data extraction from websites by parsing HTML documents. We will also look at the Selenium framework to automate web actions such as mouse click and keyboard actions on different websites.
In Chapter 6, we will look at various file-based automations for different file types in Python. We will discuss some of the Python libraries that are used to automate different file types. We will also look at ways to extract data from PDF documents and Word documents type file structure.
In Chapter 7, we would learn to automate email-based tasks using Gmail, Outlook and other SMTP clients. We will also look at Text message and WhatsApp automation using the Twilio API.
In Chapter 8, we would learn to automate Graphical User Interface (GUI) by controlling the Keyboard and Mouse Actions. We will be using the Python library PyAutoGUI which works with Windows, Mac and Linux and provides automations for GUI elements within the application.
In Chapter 9, we will look at computer Image fundamentals and the Pillow Python library for manipulating images. We would also look at the Tesseract library which can be used to extract text within images and scanned documents.
In Chapter 10, we will look at scheduling automations using dates and timers. We would also look at external applications that can allow us to run automations based on certain events such as receiving a new email or during the start of an application.
In Chapter 11, we will look at methods to extend your Python scripting knowledge and develop complex end to end process automations based on your requirements. We will learn how to work with external libraries and use external code to build these automations. We would also look at creating Python web services and using Machine Learning for automation.