Python Programming for Excel Users – NumPy, Pandas and More!
Wanting to learning Python for Excel Use cases? I’ll show you the basics here. We’ll cover the fundamentals of python, numpy, pandas, and matplotlib, to get you to a functional level of using python with your excel workbooks.
We’ll start with a python bootcamp that will get complete beginner to a python user who can execute scripts and create functions.
Once we complete the bootcamp, we’ll go through tools of the trade lessons where you’ll learn all the things that can help make you a better python developer.
After completing that, we’ll introduce NumPy, and go through practice exercises to get you functional with our first python library, NumPy.
We’ll iterate over some more tools of the trade sections for software that will make you a stronger developer.
Then we’ll get into the fun part and look at how we can begin using pandas to do our data manipulation tasks.
Throughout the course, the main emphasis is to provide you project use cases that I hope will resemble your own use cases. I want to be coding on your own data ASAP and the goal of the projects is to provide you the tools to do so.
Welcome to the Course! Brief chat before we get started.
Short intro to Download Section
Download instructions for Mac OS
Special Guest Jen Introduces how to install python for Windows
Tools of the Trade - 1
We'll go over what the purpose of a text editor is, why it's helpful, and a few suggestions of ones to try out
Brief look at documentations
Python Boot Camp - Level 1
Welcome to Python Boot Camp level I
Introduction to using Python Variables, Data types, and how we can check types and use print statements
Introduction to operators and operands
Brief Review of Operators
Deeper dive into python data types and more composite data types
Let's look at control flow logic
Ready to unlock the power of python? Let's look at how to create functions
Project 1 -
Introduction to our first project - Playing around with dtypes and search logic
Python Boot Camp - Level 2
Introduction to accessing attributes and methods
Briefly talk about other standard libraries that come included with python
How to use the Python Package Manager - Pip!
Brief Rundown of how we can use jupyter notebooks
Python Boot Camp - Level 3 (NumPy)
Introduction to why we may want to use NumPy and install
Introduction to NumPy Arrays
Let's Work with NumPy Arrays
Introduction to Indexing and Reshaping NumPy Arrays
Practice Reshaping and Indexing Arrays
NumPy Array Math Practice
Python Boot Camp - Level 4 (Pandas)
Introduction to Pandas, read excel methods, and what to expect
Introduction to Pandas DataFrames and how we can manually construct them
Introduction to kaggle.com and downloading the csv file for the upcoming lecture
We'll look at different methods of input and outputting our data using pandas
In this one we'll fire up a jupyter notebook and work on data selection methods
We'll look at groupby, describe and boolean indexing
Project 2 - Custom Excel Reports (Code Along)
Introduction to our Code Along Project
Joining Together Data Using the Concat method - Brief discussion about the concat axis keyword
How to create new dataframe columns and do simple calculations
Boolean Indexing Example working through our project
How to get quick insights into our data
Tools of the Trade - 3
Stack Overflow <3
Brief Introduction to GitHub
Python Boot Camp - Level 5 (Matplotlib)
Download of Matplotlib
In this one we'll create our first graph with matplotlib and look at how we can add more things to our graphs
We'll talk about bar, histo2d, barh graphs in this one
How we can plot dataframe information
Capstone Project - Automate Excel Reporting
How can we select data only when specific criteria are met?
We'll do Pandas Series Calculations in this one
Programmatically Automate Excel Reports Using Python
Wrapping Up & Thank You!
Thanks so much!
Python Reference (Optional Content)
Deeper look at Python Syntax and Commenting
Deeper look into variables and data types
Deeper look into composite data types
Deeper look into working with Python Numbers
Intro to Tuple Values
Introduction to Sets and Frozensets
Retouching on Dictionaries
Looking at If Statements Again
Looking at While Loops again
Revisit to For Loops
Visiting Functions again
Class Objects in Python Introduction
Bonus Content: NumPy
More NumPy Topics! Default Arrays in this one
Practice Using NumPy Default Arrays
NumPy Advanced Indexing Lesson
We'll work with NumPy Advanced Indexing a little more in this project video.
Introduction to NumPy Broadcasting