Python Programming To Automate Common Tasks

Automate the Boring Stuff with Python: Practical Programming for Total Beginners by super Python expert Al Sweigart is a pretty thick intermedia to somewhat advanced level programming book.

It covers how Python works, so someone familiar with programming languages can get up to speed. Then, the book tackles a number of key important tasks one may use a computer for. This includes working with Regular Expressions, file reading and writing, web scraping, interacting with Excel spreadsheets and PDF files, scheduling things, working with email, manipulating images, and messing around with the keyboard and mouse.

I wold like to see a second volume with yet more programming ideas and examples. It could be a series.

From the publishers:

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 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. Once you've mastered the basics of programming, you'll create Python programs that effortlessly perform useful and impressive 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 reminder emails and text notifications
  • Fill out online forms
  • Step-by-step instructions walk you through each program, and practice projects at the end of each chapter challenge you to improve those programs and use your newfound skills to automate similar tasks.

    Check it out.

    More like this

    Have a look at the list of books, below. Would you like a subset, or all, of these books, in electronic format, for very cheap? There is a way to do that. Note: This is time sensitive, the offer running for just about two weeks and it started yesterday. I've reviewed several of these books on…
    Ah yes, I remember it well. "Hammurabi, Hammurabi, I beg to report to you, In Year 1, 0 people have starved. 101 people came to the city The population is now 124 We harvested 4.5 bushels per acre We planted 998 acres of wheat But rats at 300 bushels of wheat You now have a surplus of 1443 bushels…
    The next interesting variant on graphs is directed graphs, or digraphs for short. A digraph is a graph where each edge distinguished between its source and its target - so an edge is from one node, and to another node. Unlike a simple graph, where if A is adjacent to B, then you can follow the…
    Your objective is to learn Python programming. Everybody has to learn Python. You are looking for a book that will make that easier for you. One possibility, one that I'll recommend for most people in this situation, is Python Crash Course: A Hands-On, Project-Based Introduction to Programming…

    Just want to say, "Thanks again."

    I took the time yesterday to sit down and learn enough Python to automate inspection of 8000 Excel files. I collected the filename, file size, the last modification date, names of all worksheets in each workbook, the names and cell ranges of all Defined Names in each worksheet, a list of all external links, and the cell value for a particular Defined Name (where it existed).

    I spent a dozen hours on the project, but much of that was because I kept adding to the information being retrieved. This wasn't a 'mission critical' project, In other words, it never would have been done without automation :)

    By Kevin ONeill (not verified) on 28 May 2017 #permalink