Module 3: DataFrames & Importing Data

This module is where the data wrangling begins in earnest. You’ll learn to load data from files and databases into pandas DataFrames, explore their structure, and start selecting and filtering rows and columns. By the end of Week 3, you’ll be able to take a raw data file and quickly understand what’s in it.

Learning Objectives

By the end of this module, you will:

  • Read data from CSV, Excel, JSON, and database sources into pandas DataFrames
  • Inspect a DataFrame’s shape, columns, dtypes, and summary statistics
  • Select columns and filter rows using boolean indexing
  • Understand the relationship between a pandas Series and a DataFrame

Module Resources

Lecture

Resource Link
📊 Week 3 Slides View slides
💻 Week 3 Data Detective Open in Colab

Chapters & Notebooks

Each chapter has a companion Colab notebook with all the code from the chapter — ready to run, no installation required.

Chapter Topic Colab Notebook
7 Importing Data Open in Colab
8 DataFrames Open in Colab
9 Subsetting Data Open in Colab

Lab

Resource Link
🧪 Lab 3 Open lab

Reference

Resource Link
📋 Module 3 Cheat Sheet View cheat sheet