Data Analysis

Draw meaningful conclusions from data whether you’re a business analysis, data engineer, or data scientist.

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

Save Pandas DataFrames into SQL database tables, or create DataFrames from SQL using Pandas' built-in SQLAlchemy integration.

An Unimaginably Boring Illustration of Excel Usage

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).

An Absolute Mess of Excel Data

Dealing with Dirty Data in Excel

Cleaning data Excel in the absence of tools designed to do so.

Doing the Excel Data Dance

Doing the Excel Data Dance

Taking a step back to reflect on the problems Excel intends to solve.

Adventures in Excel: Power to the Pivot

Adventures in Excel: Power to the Pivot

Power up your Excel Pivot Tables with these pro moves.

Galaxy Brain Transcending Reality By Using Excel

The One Excel Formula to Rule Them All

Unlock the secrets of Excel's Index Match.

Dropping Rows of Data Using Pandas

Dropping Rows of Data Using Pandas

Square one of cleaning your Pandas Dataframes: dropping empty or problematic data.

Merge Sets of Data in Python Using Pandas

Merge Sets of Data in Python Using Pandas

Perform SQL-like merges of data using Python's Pandas.