Python Programming for Excel Users - NumPy, Pandas and More!

Short intro to Download Section

Download instructions for Mac OS

Special Guest Jen Introduces how to install python for Windows

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

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

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

Introduction to our first project - Playing around with dtypes and search logic

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

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

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

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

Stack Overflow <3

Brief Introduction to GitHub