Data Analysis

Prepare reports and draw meaningful conclusions from data. Learn to clean and manipulate datasets to draw meaningful conclusions from existing information.

Recasting Low-Cardinality Columns as Categoricals

Recasting Low-Cardinality Columns as Categoricals

Downcast strings in Pandas to their proper data-types using HDF5.
Removing Duplicate Columns in Pandas

Removing Duplicate Columns in Pandas

Dealing with duplicate column names in your Pandas DataFrame.
Using Hierarchical Indexes With Pandas

Using Hierarchical Indexes With Pandas

Use Panda's Multiindex to make your data work harder for you.
Reshaping Pandas DataFrames

Reshaping Pandas DataFrames

A guide to DataFrame manipulation using groupby, melt, pivot tables, pivot, transpose, and stack.
Welcome to SQL: Modifying Databases and Tables

Welcome to SQL: Modifying Databases and Tables

Brush up on SQL fundamentals such as creating tables, schemas, and views.
Geocoding Raw Datasets for Mapbox

Geocoding Raw Datasets for Mapbox

Use the Mapbox Python SDK to transform a collection of addresses into lat/long coordinates.
Dynamic Tension! Creating and Using Dynamic Named Ranges in Excel

Dynamic Tension! Creating and Using Dynamic Named Ranges in Excel

Dynamically load data in smart pivot tables.
Connecting Pandas to a Database with SQLAlchemy

Connecting Pandas to a Database with SQLAlchemy

Easily drop data into Pandas from a SQL database, or upload your DataFrames to a SQL table.
Getting Iffy With it: Conditional Statements in Excel

Getting Iffy With it: Conditional Statements in Excel

Effectively utilize conditionals such as IF statements in your Excel workflow.
Taking Out the Trash: Dirty Data in Excel

Taking Out the Trash: Dirty Data in Excel

Dealing With Dirty Data in Excel (continued).