Why an embarrassment? Because it’s the name for a group of pandas!

DataFrames

Series

Missing Values

Method Chaining

Aggregation

New Columns

Feature Engineering

Random

PDF Version of this article.

DataFrames

Options — documentation

Useful read_csv() options — documentation

Read csv from URL or S3 — s3fs

Read an Excel file — documentation

Read multiple files at once — glob

Recursively grab all files in a directory

Read in data from SQLite3

Read in data from Postgres — bigquery, snowflake

Normalizing nested JSON — documentation

Column headers

Filtering DataFrame — using pd.Series.isin()

Filtering DataFrame — using pd.Series.str.contains()

Filtering DataFrame & more — using df.query() — documentation

Joining — documentation

Select columns based on data type

Apply function to multiple columns of a certain data type

Reverse column order

Correlation matrix

Descriptive statistics

Styling numeric columns — documentation

Add highlighting for max and min values