Skip to main content
Back to top
Ctrl
+
K
How to Interact With This Book
1. Python Refresh
Comments, Variables & Assignment
Data Types & I/O
Operators
Data Structures
Control Flow, Iteration & Loops
Application
2. Data Structures & Sources
Structured Data
Loading Data
Web APIs
South Bend Open Data Portal
U.S. Census Bureau
Working With PDFs
Application
3. Relational Databases
From Table To Database
Terminology
Entity Relationship Diagrams
Relational Schema
Application
4. SQL
Background & Setup
Basic Syntax
Selecting & Sorting
Filtering & Conditions
Subqueries & Wildcards
Aggregating & Calculating
Joins & Views
From SQL to Python
Other Database Workflows
Application
5. Data Wrangling
Interacting With a DataFrame
Selecting
Sorting
Filtering
Time Series Data
Reshaping
Pivot
Pivot Table
Melt
Transpose
Explode
Merging & Joining
Merge
Concat
Labels & Indexing
Putting It All Together
Application
6. Tidy Data
Tidy Data Principles
Dealing With Messy Data
Getting Started With OpenRefine
Loading Data in OpenRefine
Using OpenRefine
Spreadsheet Programs
Data Entry Workflows
Surveys & Forms
Validation & Spreadsheet Programs
Data Validation in Microsoft Excel
Data Validation in Google Sheets
Application
Text Processing Workflows
Application
7. Data Analysis
Core Concepts
Aggregating & Calculating
Summary & Descriptive Statistics
Making Calculations
Grouping & Counting
More Advanced Modeling Workflows
Application
8. Data Visualization
Data Visualization Principles
Choosing a Chart Type
Working With Visual Cues
Essential Components
Additional Resources
9. Matplotlib
Introduction to Matplotlib
Matplotlib Basics
Customizing in Matplotlib
Colormaps
Style Sheets
Legends
Other Plot Types
Scatterplots
Histograms
Bar Charts
Pie Charts
Box Plots
Subplots
Saving & Exporting
Additional Resources
Object-Oriented Workflows
Application
10. Plotting With Pandas
Overview
Customizing Your Plot
Using Matplotlib Syntax
Other Plot Types
Bar Charts
Histograms
Box Plots
Area Plots
Pie Charts
Handling Missing Data
City of South Bend Budget Data Case Study
Plotting With Seaborn
Application
11. Interactive Visualization
Introduction to Plotly
Plotly Mechanics
Plotly Express Workflows
Other Plot Types
Line Plots
Bar Charts
Pie Charts
Donut Charts
Sunburst Charts
Bubble Charts
Tables
Additional Resources
Working With Categorical Data
Saving & Exporting
User Interactivity
Dash
Application
12. Mapping
Data Formats & Structures
Working With GeoPandas
Loading Data
Visualizing Data
Interactive Maps
Outline Maps
Outline Maps & Point Data
Outline Maps & Polygon Data
Tile Maps
Tile Maps & Base Layers
Tile Maps & Point Data
Tile Maps & Polygon Data
Application
Repository
Open issue
Search
Error
Please activate JavaScript to enable the search functionality.
Ctrl
+
K
