Duke University - Python and Pandas for Data Engineering 

Overview of Python, Bash and SQL Essentials for Data Engineering

Meet your Course Instructor: Kennedy Behrman

Overview of Key Concepts

Introduction to Setting Up Your Python Environment

Installing Packages with pip in Python

Saving Requirements File in Python

Creating and Using a Python Virtual Environment

Expression Statements in Python

Assignment Statements in Python

Import Statements in Python

Other Simple Statements in Python

Compound Statements in Python

If Statements in Python

While Loops in Python

Functions in Python

Meet your Supporting Instructors: Alfredo Deza and Noah Gift

Course Structure and Discussion Etiquette

Evaluating to True or False

Assignment Statements

Import Statements

If Statements

While Loops

Python Statements

Introduction to Python Essentials

Sequences in Python

Lists and Tuples in Python

Strings in Python

Creating Range Objects in Python

Creating Dictionaries in Python

Accessing Dictionary Data in Python

Dictionary Views in Python

Sets and Set Operations in Python

List Comprehensions in Python

Generator Expressions in Python

Generator Functions in Python

Sequence Operations

Lists and Tuples

Range Objects

Accessing Data in Dictionaries

Sets and Set Operations

List Comprehensions

Generator Expressions

Essential Python Concepts

Introduction to Data in Python: Pandas and Alternatives

Creating Pandas DataFrames in Python

Investigating Data in a Pandas DataFrame

Selecting Data in a Pandas DataFrame

Manipulating Pandas DataFrames

Updating Pandas DataFrame Data

Applying Functions in a Pandas DataFrame

Creating NumPy Arrays in Python

Spark and PySpark DataFrames in Python

Creating Dask DataFrames in Python

NumPy

PySpark

Dask

Pandas and Alternatives

Introduction to Python Development Environments

Introduction to Vim Normal Mode

Switching from Normal to Insert and Visual Modes in Vim

Working with the Vim Command Line

Vim Configuration

Introduction to Visual Studio Code

Setting Up Visual Studio Code

Debugging Visual Studio Code

What is Version Control?

Introduction to Git and Git Concepts

Version Control with GitHub

Summary of Python and Pandas for Data Engineering

Insert and Visual Modes

Vim Command Line Mode

Features of Visual Studio Code

Version Control

Git Commands

Hosted Git

Cumulative Python and Pandas for Data Engineering Quiz