What are Jupyter Notebooks

Essential Jupyter Hotkeys

Getting Started with Jupyter Notebooks

The Basic Jupyter Interface

Hotkey Challenge

Basic NumPy Concepts

Working with NumPy Arrays

Accessing and Slicing NumPy Arrays

Challenge & Solution NumPy Array Practice

Other Ways to Create NumPy Arrays

Solution

Multi-Dimensional Arrays

Accessing Multi-Dimensional Array Values

Slicing Multi-Dimensional Arrays

Challenge & Solution 4D Arrays

Solution

NumPy Array Attributes

Reshaping and Resizing Arrays

Concatenating and Removing Array Elements

Challenge & Solution np.lexsort

Integer Array Indexing

Combining Integer Indexing with Slicing

Challenge & Solution Combining Integer and Boolean Indexing

Boolean Array Indexing

Array Broadcasting Basics

Broadcasting with Arrays of Different Sizes

Challenge

Resizing and Reshaping with Broadcasting

Manipulating Toy Datasets with NumPy

Using Toy Datasets

Using NumPy's Descriptive Statistics Functions

Challenge

Using NumPy's .mean Method

Introduction to Pandas

Accessing and Manipulating Pandas Series

Creating Pandas Series

Useful Series-Creation Functions

Creating DataFrames

Adding and Removing Columns

Accessing Rows and Columns on DataFrames

NumPy Integer Types

NumPy Float Types

Other Common Data Types

Generating Random Floats

Generating Random Integers

Generating Random Numbers from Distributions

Making Random Selections from Arrays

Loading and Viewing CSV Datasets

Basic Data Exploration

Viewing Unique Values

Challenge Your Turn

Renaming DataFrame Columns

Finding Missing Values in DataFrames

Viewing Rows with Missing Values

Handling Missing Values

Retyping DataFrame Columns

Grouping DataFrames By Column

Setting Up a Dataset

Grouping By Multiple Columns

Introduction to Pandas Categories

Aggregation Functions

Grouping Non-Categorical Data

Filtering Pandas DataFrames

Filtering Groups of Series

Filtering Pandas Series

Filtering Groups of DataFrames

Transforming Series

Transforming Series Using Lists and Dictionaries

Transforming DataFrames

Transforming Groups

Applying Functions to Rows

Applying Functions to Columns

Applying Functions to Entire DataFrames

Applying Functions to Cells

Sorting Series

Sorting DataFrames by Column

Reordering DataFrame Columns

Getting the Largest and Smallest Values

DataFrame Sorting Settings

Challenge

Solution

The Basic Web Scraping Process

Basic Parsing with BeautifulSoup

Loading and Parsing HTML

Scraping a Website with BeautifulSoup

The 4 BeautifulSoup Types

The BeautifulSoup Tag Type

The NavigableString Type

Finding Multiple Elements

The Basics of Finding Elements

Finding Parent Elements

Finding Sibling Elements

CSS Tag Selectors

The Basics of Using CSS Selectors with BeautifulSoup

CSS Class and ID Selectors

CSS Attribute Selectors

Selector Lists and Child Combinators

Additional Attribute Value Selectors

The Descendant Combinator

The Next-Sibling and Subsequent-Sibling Combinators

The First- and Last-of-Type Pseudo-Classes

The First- and Last-Child Pseudo-Classes

The not Pseudo-Class

The has Pseudo-Class

What is XPath

Using XPath in Jupyter

Absolute and Relative XPaths

Selecting Elements by Attribute Value

Selecting Elements by Position

Selecting Text and Attributes from Elements

The Basics of XPath Axes

More XPath Axes

What are Predicates

Challenge More Recipe Scraping

Other Ways of Filtering By Attributes

Filtering With Non-Attribute Properties

Path-Related XPath Predicates

Case-Insensitive Comparisons

Using Axes in Predicates

Displaying a Line Plot

Plotting Multiple Lines

Customizing Plots

Customizing Scatterplot Appearance

Scatterplot Basics

Color-Mapping Scatterplots

Plotting Multiple Datasets

Displaying Basic Bar Charts

Adding Annotations to Bars

Customizing Bar Chart Appearances

Drawing Different Bar Chart Types

Displaying Basic Pie Charts

Customizing Pie Chart Appearances

Drawing Different Types of Pie Charts

Displaying Histograms

Drawing Boxplots

Customizing Histograms

The Different Parts of a Figure

Displaying Multiple Plots

Controlling Axes Layouts

Another Way to Display Multiple Plots

The Slider Widget

Responding to Widget Updates

The Range Slider Widget

The RadioButtons Widget

The Button Widget

The RectangleSelector Widget

Seaborn Basics

Seaborn's Built-in Datasets

The Different Plot Types

Challenge Your Turn!

A Basic Demonstration

The .relplot Function

Changing Datapoint Appearances

Separating Data Into Multiple Plots

The Different Types of Categorical Plots

The .catplot Function

Using Specific Categorical Plot Functions

Creating Test Data with Scikit Learn

Basics of the K-Nearest Neighbor Algorithm

Predicting a Single Data Point

Using Training and Test Sets

Intro

Making Predictions

Fitting a Line with Scikit Learn

The Basics of K-Means Clustering

Running the K-Means Algorithm

Choosing the Optimal Number of Clusters

Additional K-Means Details

The Basics of Neural Networks

Constructing Neural Networks

Training a Neural Network

The Basics of Classification Trees

Finding Possible Splits

Deciding on the Best Split

Splitting Recursively

What are Descriptive Statistics

Measures of Central Tendency

Measures of Variability

Different Types of Distributions

Useful Properties of the Normal Distribution

Z-Scores and How to Use Them

The Normal Distribution In-Depth

Samples vs. Populations in Statistics

What is Correlation

Challenge Correlation of Real-World Data

Common Correlation Misconceptions

Calculating Correlation in Datasets

Correlation Heat Maps

What is Inferential Statistics

Basics of Hypothesis Testing

Hypothesis Testing in Jupyter

The Central Limit Theorem

Bootstrapping Basics

A Central Limit Theorem Demonstration

A Bootstrapping Demonstration

The SQL Landscape

Connecting to SQL Databases in Jupyter

Making SQL Queries

Making Queries with Magics

The SELECT Statement

The ORDER BY Clause

The WHERE Clause

Other WHERE Clause Situations

Basics of SQL Tables

Creating SQL Tables

Inserting Data Into SQL Tables

SQLite's Data Types and Constraints

Deleting SQL Rows

Deleting and Altering SQL Tables

Advanced UPDATE Usage

Updating SQL Rows

What Are Table Relationships

Performing Joins in SQL

One-to-One Relationships

One-to-Many Relationships

Many-to-Many Relationships

Using Aggregate Functions in Queries

Aggregate Functions

The GROUP BY Clause

The HAVING and DISTINCT Keywords

Basics of Subqueries

Single-Row Subqueries

Correlated Subqueries

Multi-Row Subqueries

Basics of Transactions

Performing SQL Transactions

SQL Transactions with the sqlite3 Module

Rolling Back Transactions