Data Analysis with Pandas

Data Analysis with Pandas

Analyze and manipulate data with Pandas, the iconic Python library for tabular data. Learn to load, transform, and prepare data for visualizations or analysis via Python data science libraries. Explore advanced topics such as hierarchical indexing and data shaping to pay dividends down the line.

What You'll Learn

Loading data from a myriad of sources into Python.
Sanitize data for analysis.
Perform complex joins & table operations.
Create beautiful data visualizations from DataFrames.
Read & write directly from SQL databases.
Powerful hierarchical indexing.

For those who...

Have a basic understanding of Python.
Are entering the Data Science & Analysis field.
Find interest in discovering new Pandas features.

Another 'Intro to Data Analysis in Python Using Pandas' Post

An introduction to Python's quintessential data analysis library.

Merge Sets of Data in Python Using Pandas

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

Dropping Rows of Data Using Pandas

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

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.

Automagically Turn JSON into Pandas DataFrames

Let Pandas do the heavy lifting for you when turning JSON into a DataFrame.

Lazy Pandas and Dask

Speed up data analysis by parallelizing your DataFrames.

Parse Data from PDFs with Tabula and Pandas

Parse data from PDFs into Pandas DataFrames by using Python's Tabula library.

Data Visualization With Seaborn and Pandas

Create beautiful data visualizations out-of-the-box with Python’s Seaborn.

Reshaping Pandas DataFrames

A guide to DataFrame manipulation using groupby, melt, pivot tables, pivot, transpose, and stack.

Using Hierarchical Indexes With Pandas

Use Panda's multi-index to create smarter datasets. Speed up your workflow by easily selecting and aggregating related data.