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

#Python #Automation #Excel

Here's the excel workbooks from this video --

Here's the full python beginners course to get you started using python-

Playlists you might consider interesting:
Pandas for beginners

NumPy Course (Free from Udemy)

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!

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

print(df_first_shift)
print(df_first_shift['Product'])

print(df_all)

print(shift_productivity)

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:

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!

[rccc]

This lesson would take more than 30 minutes for others to explain. Great pace & clarity. This is usually the best way to explain something for non-beginners. This is the essence! Thank you so much!

[slyfox]

This guy is going places! It wasn’t too long ago when I watched one of your videos and you only had a couple thousand subs. Keep up the great work! Love your videos

[panditadata]

Love😍your videos... So clear and straight to the point...high quality

[CodeWithDerrick]

Sorry for the technical errors on this one (learning premiere and animations to improve the videos haha) - Medium & Advanced level techniques coming soon!

[ApteryxRex]

Just stumbled across this. Thanks so much - a clear, easy to follow example. Great stuff!

[pablogcortez]

This tutorial is great, thank you so much!

[shaurya]

Really sweet person knows what he is doing and is not all about money and friggin sponsors. Keep it up! Makes me cry happily!

[thejohnhoang]

dude thank you so much for this tutorial. i can't thank you how helpful you are to the data analysis community!

[MrStuartAllan]

Brilliant video, I have heard python mentioned numerous times but never seen it in action. Looks amazing, thanks for making the video!

[joaquinsancaro]

You have no idea how valuable this is to me. Thank you so much. Great content!

[edsonwinnerify]

I have a lot of things to learn from you man. Keep your videos coming up! Thanks

[michelleamidon]

I'm going to drop all professionalism and just say " holy shit "". I've watched ALOT of training videos On python but WOW...it was short, clear, concise, and understandable. I know the video is 2 yrs old but I hope he is having all the success he deserves!! Well done!!!!

[riteshtripathi]

Youtube's algo popped up your video and this the first video to watch on your channel and I am subscribed to it. Thanks, this has been a great relieve for my production planning, though I am new in python.

Hi Derrick, I was nine when Apollo 11 was launched so, despite the difference of timelines between you and me, I feel very enthusiastic about my Python learning curve. I will utilize your instructive videos in order to implement a project on a native american language I am learning here in Central America. As things go further in my idiom classes the more rules appear, therefore I am expecting about storing different sources in different Excel files and combine them, with the proper sintactic rules, in some sort of a centralized dictionary. I have recorded the important features of this video for further use. Thanks.

[christopherdismuke]

Great content. I don’t see enough people talking about excel -> python.

[dylanyespersen]

Amazing Tutorial, Derrick. Thank you so much :)

[lucianotavares]

Thank you for sharing your knowledge! Very useful easy to understand! 👍

[TheYasinsonu]

Great Video! Helps me alot in day to day work. Thank you Derrick.

[JohnsonKongor]

Thanks, Derrick. Great job. I have worked with excel for over 15 years, manipulating data with excel multiple functions. But I still give credit to python and other programming languages for data automation. I'm transitioning.

[claytonmarquardt]

really good stuff. videos like these are great because we're doing real work and it helps me learn! thanks again.