Login
MetaSnake Products/Effective Pandas - Standard
Buy now

  • $99 or 3 monthly payments of $40

Effective Pandas - Standard

Learn modern Pandas.
Buy now

Contents

Introduction

Welcome to the Effective Pandas course.
01-intro.mov

Bonus Materials

This has the cheatsheet and flashcards

pandas-metasnake-cheatsheet.pdf
Pandas Exercises.ipynb
ep-cheats.zip

Installation

This video will walk you through installing Pandas and Jupyter on your machine. You can also reference this post I have created https://www.metasnake.com/blog/pydata-dev.html
Pandas Overview.ipynb
02-install.mov

Jupyter

We will be leveraging the Jupyter environment through this course. This will introduce you to it.
03-jupyter.mov
Preview
ex-01-jup.mov

Teaser Overview

This section walks through a bit of what you can expect from this course.
04-teaser.mov

Loading Data

This section walks through loading data from CSV, Excel, or databases.
05-loading-data.mov
Preview
ex-02-load.mov

Exploring Data

You will need to inspect your data after you load it. This section walks you through common steps.
06-view.mov
ex-03-inspect.mov

Tweaking Data

This section demos how to change your data.
07-tweak.mov
ex-04-tweak.mov
Preview

Statistics

Quantifying your data is useful. Let's see how to do it!
08-stats.mov
ex-05-stats.mov

Visualization

Viewing data can provide insight into the data a well. A picture says a 1000 words!
09-plotting.mov
ex-06-plotting.mov

Filtering Data

Slice and dice...
10-filter.mov
ex-07-filter.mov

Filtering with .loc

Pulling out in index and columns by value.
11-loc.mov
ex-08-loc.mov

Filtering with .iloc

Pulling out data by position.
12-iloc.mov
ex-09-iloc.mov

Dealing with Missing Data

How to handle data that is missing.
13-missing.mov
ex-10-missing.mov

Pivoting and Grouping

Create Pivot Tables from Pandas.
14-grouping.mov
ex-11-grouping.mov

Joining and Merging Data

Combining data from different sources.
ex-12-joining.mov
15-join.mov
2004-PM2.5.csv