Week 06

Pandas II: Data Wrangling

Lectures Notes:

Today, we will go over three notebooks and you have a additional notebook to work by yourselves:

• Pandas - Data Loading and Writing: html – Jupyter Notebook

• Pandas - data wrangling: html – Jupyter Notebook

• Pandas - Joining Data : html – Jupyter Notebook

• Pandas Miscellaneous: html – Jupyter Notebook

Datasets

Download the datasets here

Slides

• Pandas: Data Wrangling

Readings

Suggested Readings for Pandas

• PDS VanderPlas

• Ch. 4: Data Manipulation with Pandas

• Tidy Data in Python

• Tidy Data by Hadley Wickham in R

And all our lecture notes!

• Additional Resources and Suggested Materials

  • Python Pandas Tutorial: A Complete Introduction for Beginners

  • Data Wrangling with Pandas Cheat Sheet - pandas.pydata.org

  • dplyr-style Data Manipulation with Pipes in Python - Allen, Akinkunle

  • Python Pandas vs. R Dplyr - The Full Cheatsheet - Martin Šiklar

  • Methods Chaining in Pandas

  • The Pandas Assign Method and Chaining

• Exercises in Pandas