PYTHON AUTOMATION COOKBOOK 75 PYTHON AUTOMATION IDEAS FOR WEB SCRAPING, DATA WRANGLING, AND PROCESSING EXCEL, REPORTS, EMAILS, AND MORE.: 75 PYTHON AUTOMATION IDEAS FOR WEB SCRAPING, DATA WRANGLING, AND PROCESSING EXCEL, REPORTS, EMAILS, AND MORE. (2020)

• Record Type: Book
• Other Names: BUELTA, JAIME
• Contents: 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
• Edition: Second edition
• Publisher Details: S.l. : PACKT PUBLISHING
• Publication Date: 2020
• Extent: 1 online resource
• Subjects: 005.133; Python (Computer program language); Application software -- Development; Computer networks -- Management; Application software -- Development; Automation; Electronic data processing; Python (Computer program language); Electronic books
• Languages: English
• ISBNs: 1800202598; 9781800202597
• Related ISBNs: 9781800207080
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.