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 Series"

#python #pandas #automation
Here's the excel workbooks if you want to follow along:

If executing your python script against a workbook isn't hands off enough, CRON jobs can automate the execution of a script or application. If you want to learn about that from me, just let me know and I'll make a video on it.

Merch Store --
Support the Channel on Patreon --
Join The Socials --
*****************************************************************
Full code from the video:

import pandas as pd

excel_book_1_relative_path = 'Purchases - Home B.xlsx'

#print(df_prices, df_home_1)

df_total['Total Price'] = df_total['PURCHASED AMOUNT'] * df_total['Price']

#print(df_total)

Packages (& Versions) used in this video:
pandas 1.1.2
plotly 4.9.0

*****************************************************************
Code from this tutorial and all my others can be found on my GitHub:

Crazy how far the channel has come! 41,940 subscribers at the time of writing. I'm still amazed by all the support and love you guys show me. Crazy how making videos for my coworkers teaching them HTML has turned into an audience of thousands. Thanks for giving me the opportunity to make content for you all!

Check out my website:

If you liked the video - please hit the like button. It means more than you know. Thanks for watching and thank you for all your support!!

--- Channel FAQ --

What text editor do you use?

What Equipment do you use to film videos?

What editing software do you use?
Premiere Pro for video editing
Photoshop for images
After Effects for animations

Do I have any courses available?
Yes & always working on more!

Where do I get my music?
I get all my music from the copyright free Youtube audio library

Let me know if there's anything else you want answered!

-------------------------

Always looking for suggestions on what video to make next -- leave me a comment with your project! Happy Coding!

[stevecarter]

Great tutorial. So often the spoken content is just telling us what we seeing in the editor, but you tell it's the WHY and some generalizations. Perfect!

[briangorman]

This is absolutely fantastic - learned more from this than any other tutorial I've watched!!

[IrvinSvyrydovskyi]

Damn it. I have spent two evenings trying to find out why the code does not work, installing environments, libraries and so on. That was a great relief to see it finally works. Thanks for the tutorial and a good exercise to boost my problem-solving skills :D

[Izo_Forwarder]

well done Derrick they way you explaining make it really easy.

[vj_singh]

You make process easy and simplify things in a nice way... Thanks from India.

[srijitbhattacharya]

Amazing tutorial. I am at an above novice stage in Python and I want to pursue a career in data science and analytics. I am thankful to you for this video and I wish you can teach us more. Keep up the great work.

[mab]

Best tutorials by far! Short, simple, and to the point. Great job!

[sammckenna]

Great job Derrick -- your python videos are some of the most simple and well structured videos on spreadsheet automation using python that I have ever seen. Great job

[amitsrivastava]

you made the things easy for us dealinf with excel files, thanks so much.

[Puddlebar]

The way you teach is awesome. Waiting for your next lectures.

[blackpower]

Great video! I would really enjoy a machine learning series from you .)!

[amirmoezi]

thanks a million for you invluable content.. it's just wonderful

[rickytomatoes]

Derrick, your reviews are simple, yet articulate and easy to follow. Have you made any tutorials on processing exams or questionnaires using machine learning?

[averybrooks]

One of the best videos you've done, thanks a lot!

[E_Crypto]

Great videos Derrick, you're a talented teacher and it's much appreciated!

[nicbongo]

Great video, so easy to follow along. I'd love to see line graphs with phase change lines, as they've always been a pain on excel.

Either way, keep up the great work!

[srenjensen]

Really good explanations - much appreciated.

[tecobdevjuneja]

Very nicely explained! It was so easy to follow you! Great stuff buddy! Keep it up! 💪💪

[garyflagray]

Great video, thanks Derrick. Keep up the good work!!

[jonasoliveira]

Derrick, I have just found your channel and, honestly, it's really cool! About this video, a question: is there any way I could do a code where the user inputs the spreadsheet name and/or path before running the code?