# Python for Data Analysis

Learn to answer real questions with data in Python: load spreadsheets, CSV and JSON files into pandas tables, clean messy data, filter, group, join and…

Updated: November 19, 2026

## [Module 1: Notebooks and Tables](https://www.ask-codey.com/courses/python-data-analysis/modules/1)

Set up a data workspace with pandas and notebooks in VS Code, brush up on the Python that data work uses, then load a farmers market's sales, its Excel workbook and its app's JSON into pandas tables and find out what's in them.

- [Getting Started with Data Analysis](https://www.ask-codey.com/courses/python-data-analysis/chapters/data-getting-started) (5 topics, 13 lessons)
- [The Python You Need for Data](https://www.ask-codey.com/courses/python-data-analysis/chapters/data-python-you-need) (5 topics, 7 lessons)
- [pandas: Series and DataFrames](https://www.ask-codey.com/courses/python-data-analysis/chapters/data-pandas-tables) (5 topics, 10 lessons)

## [Module 2: Cleaning Data](https://www.ask-codey.com/courses/python-data-analysis/modules/2)

Clean real, messy data: find and handle missing values honestly, fix wrong types, remove duplicates, tidy text and parse dates, catch values that can't be right, and put every step into one cleaning function that saves a clean file, then clean a year of bike-share rides.

- [Missing Values, Types and Duplicates](https://www.ask-codey.com/courses/python-data-analysis/chapters/data-missing-types-duplicates) (4 topics, 6 lessons)
- [Text and Dates](https://www.ask-codey.com/courses/python-data-analysis/chapters/data-text-and-dates) (3 topics, 7 lessons)
- [Impossible Values and a Cleaning Routine](https://www.ask-codey.com/courses/python-data-analysis/chapters/data-cleaning-routine) (4 topics, 6 lessons)

## [Module 3: Answering Questions](https://www.ask-codey.com/courses/python-data-analysis/modules/3)

Answer real questions with data: pick rows and columns, filter and sort, add calculated columns, group and summarize, build pivot tables, total by week and month, join tables and reshape them, then answer five questions a coffee chain's manager asked.

- [Selecting, Filtering and Sorting](https://www.ask-codey.com/courses/python-data-analysis/chapters/data-select-filter-sort) (5 topics, 7 lessons)
- [Grouping and Summarizing](https://www.ask-codey.com/courses/python-data-analysis/chapters/data-grouping-and-summarizing) (4 topics, 6 lessons)
- [Joining and Reshaping Tables](https://www.ask-codey.com/courses/python-data-analysis/chapters/data-joining-and-reshaping) (5 topics, 8 lessons)

## [Module 4: Charts](https://www.ask-codey.com/courses/python-data-analysis/modules/4)

Turn answers into charts people can read: draw line, bar, scatter and histogram charts with matplotlib and pandas, choose the chart that fits the question, write titles that state the finding, keep axes honest and colors readable, and lay several charts out on one saved page.

- [Four Charts with matplotlib](https://www.ask-codey.com/courses/python-data-analysis/chapters/data-four-charts) (4 topics, 7 lessons)
- [Choosing Charts and Keeping Them Honest](https://www.ask-codey.com/courses/python-data-analysis/chapters/data-honest-charts) (5 topics, 7 lessons)

## [Module 5: A Report Someone Can Use](https://www.ask-codey.com/courses/python-data-analysis/modules/5)

Finish an analysis so someone else can use it: a notebook that tells a story with its caveats, shared as a web page; logic moved into a module and a script that rebuilds the report from new data; and tests that prove the numbers and charts are right, then build a monthly report that rebuilds itself.

- [A Notebook That Tells a Story](https://www.ask-codey.com/courses/python-data-analysis/chapters/data-notebook-story) (3 topics, 5 lessons)
- [From Notebook to Script](https://www.ask-codey.com/courses/python-data-analysis/chapters/data-notebook-to-script) (3 topics, 8 lessons)
- [Testing Your Analysis](https://www.ask-codey.com/courses/python-data-analysis/chapters/data-testing-analysis) (3 topics, 5 lessons)

Source: https://www.ask-codey.com/courses/python-data-analysis
