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


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

*

Full Code From This Example:


YouTube Description:

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 to redo that one. In this one we'll cover pandas, NumPy, and Matplotlib for creating reports from multiple excel spreadsheets. #Python #Automation #Excel Here's the excel workbooks from this video -- https://drive.google.com/open?id=1x6Zvat5QDszp95zf4PYEYV-vDdhsWS4E https://drive.google.com/file/d/16YiozndphnyBbdFmJW7VFMr8E6fyH2-r/view?usp=sharing Here's the full python beginners course to get you started using python- https://youtu.be/YJ8o-datYkI Playlists you might consider interesting: Pandas for beginners https://www.youtube.com/watch?v=dtuKSYpdcFc&list=PLc_Ps3DdrcTuu4PJB_g3oUn-wpohI_mUh NumPy Course (Free from Udemy) https://www.youtube.com/watch?v=9fcTq8PDWWA&list=PLc_Ps3DdrcTuf3e-BBpDv8r9jbOB5Wdv- Hey Everyone! In this video we're covering the basics of how to automate your multiple sheet excel reporting using python. We'll cover the basics of everything you need to get started using pandas, numpy, matplotlib and python to automate Excel. There's a lot more in depth stuff about automating excel reporting than what is covered in this video, so subscribe to the channel and I'll have the medium and advanced level videos up soon! Let me know any feedback or any trips you have for automating excel reporting and I'll be sure to feature you (and the tips) in an upcoming video. Thanks so much for watching and I hope this video helps you automate excel reporting. Join The Socials -- Picking Shoutouts Across YouTube, Insta, FB, and Twitter! 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 Thanks so much for all the support! It's crazy that this topic catapulted my channel about a year ago and now I get to type this (and make an improved version) a year later. Thanks so much for supporting me. This one feels surreal. I appreciate you all so much! 5100+ subscribers and climbing. Thank you all. ***************************************************************** Full code from the video: import pandas as pd import numpy as np import matplotlib.pyplot as plt excel_file_1 = 'shift-data.xlsx' excel_file_2 = 'third-shift-data.xlsx' df_first_shift = pd.read_excel(excel_file_1, sheet_name='first') df_second_shift = pd.read_excel(excel_file_1, sheet_name='second') df_third_shift = pd.read_excel(excel_file_2) print(df_first_shift) print(df_first_shift['Product']) df_all = pd.concat([df_first_shift, df_second_shift, df_third_shift]) print(df_all) pivot = df_all.groupby(['Shift']).mean() shift_productivity = pivot.loc[:,"Production Run Time (Min)":"Products Produced (Units)"] print(shift_productivity) #shift_productivity.plot(kind='bar') #plt.show() df_all.to_excel("output.xlsx") https://github.com/Derrick-Sherrill/DerrickSherrill.com/blob/master/AutomateExcelReporting.py Packages (& Versions) used in this video: Python 3.7 NumPy 1.17 Pandas 0.15.0 Matplotlib Mac OS operating system ***************************************************************** Code from this tutorial and all my others can be found on my GitHub: https://github.com/Derrick-Sherrill/DerrickSherrill.com 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!! Always looking for suggestions on what video to make next -- leave me a comment with your project! Happy Coding!

Enjoy this content? Consider Subbing to the Youtube channel





Derrick Sherrill

By: Derrick Sherrill

Thanks for visiting my page! I'm working hard to make the best content I can for you. I love watching people learn and teaching others. Happy Coding!

Become a Patreon!