Automation

If you’ve ever spent hours renaming files or updating hundreds of spreadsheet cells, you know how tedious tasks like these can be. But what if you could have your computer do them for you?

In this fully revised second edition of the best-selling classic Automate the Boring Stuff with Python, you’ll learn how to use Python to write programs that do in minutes what would take you hours to do by hand—no prior programming experience required. You'll learn the basics of Python and explore Python’s rich library of modules for performing specific tasks, like scraping data off websites, reading PDF and Word documents, and automating clicking and typing tasks.

The second edition of this international fan favorite includes a brand-new chapter on input validation, as well as tutorials on automating Gmail and Google Sheets, plus tips on automatically updating CSV files. You’ll learn how to create programs that effortlessly perform useful feats of automation to:

• Search for text in a file or across multiple files
• Create, update, move, and rename files and folders
• Search the Web and download online content
• Update and format data in Excel spreadsheets of any size
• Split, merge, watermark, and encrypt PDFs
• Send email responses and text notifications
• Fill out online forms

Step-by-step instructions walk you through each program, and updated practice projects at the end of each chapter challenge you to improve those programs and use your newfound skills to automate similar tasks.

Don't spend your time doing work a well-trained monkey could do. Even if you've never written a line of code, you can make your computer do the grunt work. Learn how in Automate the Boring Stuff with Python, 2nd Edition.

Take PowerShell beyond simple scripts and build time-saving automations for your team, your users, and the world.

In Practical Automation with PowerShell you will learn how to:

• Build PowerShell functions to automate common and complex tasks
• Create smart automations that are adaptable to new challenges
• Structure your code for sharing and reusability
• Store and secure your automations
• Execute automations with Azure Automation, Jenkins, Task Scheduler, and Cron
• Share your automations with your team and non-technical colleagues
• Store and retrieve data, credentials, and variables
• Use source control solutions to maintain and test code changes
• Provide front-end UI solutions for PowerShell automations

Practical Automation in PowerShell reveals how you can use PowerShell to build automation solutions for a huge number of common admin and DevOps tasks. Author Matthew Dowst uses his decades of experience to lay out a real blueprint for setting up an enterprise scripting environment with PowerShell. The book goes beyond the basics to show you how to handle the unforeseen complexities that can keep automations from becoming reusable and resilient. From the console to the cloud, you'll learn how to manage your code, avoid common pitfalls, and create sharable automations that are adaptable to different use cases.