Author: Derrick Sherrill

Example Spreadsheet Automation – Python Automation for Remote Workers Series

There’s SO many ways to “automate” spreadsheets using python programming. This is just one simple walkthrough using a couple excel workbooks. Check out the full “Python Automation for Remote Workers…

Automate Excel Pivot Tables Across Workbooks – Learn Python Pandas

Hey Everyone! Continuing the Pandas series. In this one we’ll work with multiple spreadsheets and use the GroupBy pandas function. We’ll cover: – Combining data sources – Grouping data from…

Conditional Search Multiple Excel Files – Excel Python Automation – Five Minute Python Scripts

In this video we’ll cover how to can use Python and Pandas to conditionally search for values across multiple spreadsheets and return multiple values back when the conditional is true.…

How to Automate a Python Script to Run Daily

How to Automate a Python Script to run daily using Python and PythonAnywhere Services https://www.pythonanywhere.com/ Kite helps fund the channel, thanks for checking them out and supporting me — ⭐…

How I Automated a Supply Chain with Machine Learning, AWS, and Python

In this video I cover the basics of how I automated a global supply chain using machine learning, amazon web services, and python programming. If you want a full tutorial…

Python Automation for Remote Worker Series | Automate Website Interactions

Automate Web Interacts ( We’ll do this more with APIs in part #3) Honestly each of these packages deserves full courses to go over all the cool things you can…

Combining Excel Sheets with Python – Five Minute Python Automation Scripts Tutorial

Takes several workbooks’ fields and rewrites a new excel file with only the data you want. Combine and verify data across unlimited excel workbooks with one python script. Five Minute…

Automate File Handling With Python & AWS S3 | Five Minute Python Scripts

Hey everyone! Quick Example on how we can automate the handling of different files to automatically be uploaded to amazon S3. Sorry for the green screen issues – hope they’re…

Automate Multiple Sheet Excel Reporting – Python Automation Tutorial | Full Code Walk Through (2019)

Python Automation Tutorial In this one we’ll cover the basics of how to automate your excel reports. I know I did this video previously, but I felt it was time…