Cover -- Copyright -- Packt Page -- Contributors -- Table of Contents -- Preface -- Chapter 1: 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 -- Chapter 2: Automating Tasks Made Easy -- Preparing a task -- Setting up a cron job -- Capturing errors and problems

Sending email notifications -- Chapter 3: Building Your First Web Scraping Application -- Downloading web pages -- Parsing HTML -- Crawling the web -- Subscribing to feeds -- Accessing web APIs -- Interacting with forms -- Using Selenium for advanced interaction -- Accessing password-protected pages -- Speeding up web scraping -- Chapter 4: 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 -- Chapter 5: 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 -- Chapter 6: 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 -- Chapter 7: Cleaning and Processing Data -- Prepare a CSV spreadsheet -- Append currency based on location -- Standardize the date format -- Aggregate results -- Process data in parallel -- Process data with Pandas -- Chapter 8: 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 -- Chapter 9: 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 -- Chapter 10: 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