Automate the Boring Stuff with Python, 3rd Edition

Also heard it can automate? There's literally a book written to teach people python called "Automate the Boring Stuff". I've seen folks use it to clean up data for spreadsheets. I've personally used it to gather a bunch of data from a computer and upload it to a remote server for analysis (not financial specific, I work in medical imaging manufacturing). All of the cool tools you use in finance were coded in some programming language on some level, Python is just pretty easy for laymen to learn if they're willing to put in the time to do so. I'm not familiar with power automate, so I can't really answer that question, unfortunately.