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”
— https://www.youtube.com/watch?v=saO_wEhnwc0&list=PLc_Ps3DdrcTtjOvU01ZijSntOCmfRPUqs
#python #pandas #automation
Here’s the excel workbooks if you want to follow along:
https://drive.google.com/drive/folders/1_0YFD-2Z9sitan8EbbTfMjEmhwHTAz-Q?usp=sharing
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 —
https://derricksherrill.store/
Support the Channel on Patreon —
https://www.patreon.com/join/derricksherrill
Join The Socials —
Reddit – https://www.reddit.com/r/CodeWithDerrick/
FB – https://www.facebook.com/CodeWithDerrick/
Insta – https://www.instagram.com/codewithderrick/
Twitter – https://twitter.com/codewithderrick
LinkedIn – https://www.linkedin.com/in/derricksherrill/
GitHub – https://github.com/Derrick-Sherrill
*****************************************************************
Full code from the video:
import pandas as pd
import plotly.express as px
excel_book_1_relative_path = ‘Purchases – Home B.xlsx’
excel_book_prices = ‘PriceBook.xlsx’
df_prices = pd.read_excel(excel_book_prices)
df_home_1 = pd.read_excel(excel_book_1_relative_path)
#print(df_prices, df_home_1)
df_total = df_home_1.merge(df_prices, on=’ID’)
df_total[‘Total Price’] = df_total[‘PURCHASED AMOUNT’] * df_total[‘Price’]
#print(df_total)
fig = px.pie(df_total[[‘MATERIAL’, ‘Total Price’]], values=’Total Price’, names=’MATERIAL’)
fig.show()
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:
https://github.com/Derrick-Sherrill/DerrickSherrill.com
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:
https://www.derricksherrill.com/
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?
Atom – https://atom.io/
What Equipment do you use to film videos?
https://www.amazon.com/shop/derricksherrill
What editing software do you use?
Adobe CC – https://www.adobe.com/creativecloud.html
Premiere Pro for video editing
Photoshop for images
After Effects for animations
Do I have any courses available?
Yes & always working on more!
https://www.udemy.com/user/derrick-sherrill-2/
Where do I get my music?
I get all my music from the copyright free Youtube audio library
https://www.youtube.com/audiolibrary/music?nv=1
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!
source
