Data Analysis

Cleaning, exploring and visualising data with spreadsheets, SQL, pandas and dashboards.

All levels Beginner Advanced Expert

Advanced

Once the basics are comfortable.

Window functions, nested data, analytic queries and writing efficient SQL on large tables.

Kaggle

Handle missing values, scaling, dates, character encodings and inconsistent text: the work that takes most of an analyst's time.

Kaggle

The pandas creator's own book on data wrangling with pandas, NumPy and Jupyter, free to read online.

Wes McKinney