Login
MetaSnake Products/Effective Pandas - Basic
Buy now

  • $59 or 2 monthly payments of $35

Effective Pandas - Basic

Learn modern Pandas.
Buy now

Contents

Introduction

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

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
02-install.mov
Pandas Overview.ipynb

Jupyter

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

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

Exploring Data

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

Tweaking Data

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

Statistics

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

Visualization

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

Filtering Data

Slice and dice...
10-filter.mov

Filtering with .loc

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

Filtering with .iloc

Pulling out data by position.
12-iloc.mov

Dealing with Missing Data

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

Grouping and Pivoting

Create Pivot Tables in Pandas!
14-grouping.mov

Joining and Merging Data

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