Skip to main content
`Ctrl`+`K`

# Community tutorials

This is a guide to many pandas tutorials by the community, geared mainly for new users.

## pandas cookbook by Julia Evans

The goal of this 2015 cookbook (by Julia Evans) is to give you some concrete examples for getting started with pandas. These are examples with real-world data, and all the bugs and weirdness that entails. For the table of contents, see the pandas-cookbook GitHub repository.

## pandas workshop by Stefanie Molin

An introductory workshop by Stefanie Molin designed to quickly get you up to speed with pandas using real-world datasets. It covers getting started with pandas, data wrangling, and data visualization (with some exposure to matplotlib and seaborn). The pandas-workshop GitHub repository features detailed environment setup instructions (including a Binder environment), slides and notebooks for following along, and exercises to practice the concepts. There is also a lab with new exercises on a dataset not covered in the workshop for additional practice.

## Learn pandas by Hernan Rojas

A set of lesson for new pandas users: https://bitbucket.org/hrojas/learn-pandas

## Practical data analysis with Python

This guide is an introduction to the data analysis process using the Python data ecosystem and an interesting open dataset. There are four sections covering selected topics as munging data, aggregating data, visualizing data and time series.

## Exercises for new users

Practice your skills with real data sets and exercises. For more resources, please visit the main repository.

## Modern pandas

Tutorial series written in 2016 by Tom Augspurger. The source may be found in the GitHub repository TomAugspurger/effective-pandas.

- Modern Pandas

- Method Chaining

- Indexes

- Performance

- Tidy Data

- Visualization

- Timeseries

## Excel charts with pandas, vincent and xlsxwriter

- Using Pandas and XlsxWriter to create Excel charts

## Joyful pandas

A tutorial written in Chinese by Yuanhao Geng. It covers the basic operations for NumPy and pandas, 4 main data manipulation methods (including indexing, groupby, reshaping and concatenation) and 4 main data types (including missing data, string data, categorical data and time series data). At the end of each chapter, corresponding exercises are posted. All the datasets and related materials can be found in the GitHub repository datawhalechina/joyful-pandas.

## Video tutorials

- Pandas From The Ground Up (2015) (2:24) GitHub repo

- Introduction Into Pandas (2016) (1:28) GitHub repo

- Pandas: .head() to .tail() (2016) (1:26) GitHub repo

- Data analysis in Python with pandas (2016-2018) GitHub repo and Jupyter Notebook

- Best practices with pandas (2018) GitHub repo and Jupyter Notebook

## Various tutorials

- Wes McKinney’s (pandas BDFL) blog

- Statistical analysis made easy in Python with SciPy and pandas DataFrames, by Randal Olson

- Statistical Data Analysis in Python, tutorial videos, by Christopher Fonnesbeck from SciPy 2013

- Financial analysis in Python, by Thomas Wiecki

- Intro to pandas data structures, by Greg Reda

- Pandas DataFrames Tutorial, by Karlijn Willems

- A concise tutorial with real life examples

- 430+ Searchable Pandas recipes by Isshin Inada