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 to redo that one. In this one we'll cover pandas, NumPy, and Matplotlib for creating reports from multiple excel spreadsheets.
Kite helps fund the channel, thanks for checking them out and supporting me --
⭐ Kite is a free AI-powered coding assistant that will help you code faster and smarter. The Kite plugin integrates with all the top editors and IDEs to give you smart completions and documentation while you’re typing. https://www.kite.com/get-kite/?utm_medium=referral&utm_source=youtube&utm_campaign=derricksherrill&utm_content=description-only
#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!!
--- 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!
Видео Automate Multiple Sheet Excel Reporting - Python Automation Tutorial | Full Code Walk Through (2019) канала Derrick Sherrill
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.
Kite helps fund the channel, thanks for checking them out and supporting me --
⭐ Kite is a free AI-powered coding assistant that will help you code faster and smarter. The Kite plugin integrates with all the top editors and IDEs to give you smart completions and documentation while you’re typing. https://www.kite.com/get-kite/?utm_medium=referral&utm_source=youtube&utm_campaign=derricksherrill&utm_content=description-only
#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!!
--- 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!
Видео Automate Multiple Sheet Excel Reporting - Python Automation Tutorial | Full Code Walk Through (2019) канала Derrick Sherrill
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Complete Python Pandas Data Science Tutorial! (Reading CSV/Excel files, Sorting, Filtering, Groupby)How to easily automate boring Excel tasks with Power Query!Don't Use Excel Filters! Use This Incredible Excel Formula Instead ...Build an Online KPI Dashboard from Real Time Spreadsheet Data (The Easy Way)Python Automation for Remote Worker Series | Automate Website InteractionsHow to Generate an Analytics Report (pdf) in Python!Python Tutorial for Beginners [Quick & Easy]Automate WhatsApp message || Hack WhatsApp || WhatsApp trick || Learn Python || Python ProjectBuilding a Machine Learning (Artificial Neural Network) Model - Python Data Science Intro ProjectReplace Excel Vlookup with Python - Five Minute Python ScriptsAdvanced Excel Filtering Across Workbooks Tutorial - Excel Automation with Python SeriesLearn Python - Full Course for Beginners [Tutorial]Excel VBA Beginner TutorialSolving real world data science tasks with Python Pandas!Replace Excel If Function with Python PandasWeb automation in python for beginnersWhy Python is huge in finance? by Daniel RoosSchedule and Automate Your Excel Data Analytics with PythonFully Automated Excel dashboard with multiple source files | No VBA usedAutomatic pool stick vs. strangers