Toggle navigation sidebar
Toggle in-page Table of Contents
Introduction to Python and SQL for Data Analysis
Introduction to SQL and Python for Data Analysis
Getting Started
Introduction to Jupyter Notebooks
Data
Data Analysis with Python
Introduction to Python and Pandas
Reading Data
Exploring the Data Frame
Data Types in Python
Error Messages and Documentation
Data Management in Python
Creating Subsets of the Data
Checking for Missing Values
Descriptive Statistics
Functions and Loops
Functions
Loops
Visualizations
Basic Visualizations
Other Plotting Libraries
Example: Line Chart Over Years
SQL
Introduction to SQL and Relational Databases
Relational Databases
Writing a Basic Query
Checking Number of Rows and Duplicates
Using Conditional Statements
Using Aggregation Functions
SQL Joins
Joins
Different Types of Joins
Using Joins With Aggregation Functions
Creating New Tables for Future Use
SQL in Python
Using SQL and Python Together
Creating a Connection
Reading SQL tables using Pandas
Writing Data Frames to an SQL Database
Example: Finding Jobs by County over Years
Index
