Pandas Playbook: Manipulating Data
Pandas is one of the most popular software packages for data analysis. This course focuses on the core functionalities of Pandas for data wrangling, teaching you how to tackle everyday tasks for a data analyst, or data scientist.
What you'll learn
Pandas is not just one of the most popular software packages for data analysis, it is also, without a doubt, the most convenient and fun way to work with your data. In this course, Pandas Playbook: Manipulating Data, you will cover the most important core functionalities of Pandas, focusing on the core functionalities of the two main Pandas classes: the DataFrame and the Series. First, you will take a look at a new dataset and try to get a feeling for it - how many rows and columns are there? What datatypes does it consist of? You will do some basic statistical exploration as well. Then, you'll focus on getting information out of your dataset. Basically, it's about asking the right questions and drilling down into your dataset. Finally, you will learn how to clean and transform your data. Here, you will see how to run Python functions against our data, including functions we write ourselves by using a very cool and powerful feature called groupby() - changing the structure of our columns and rows, and combining multiple dataframes into one. After watching this course, you will be ready for just about any data wrangling job that you might come across.
Table of contents
- Module Overview 1m
- Demo: Mathematical Operators 7m
- Demo: Function Application 4m
- Review: Math Operators and Function Application 5m
- Demo: Grouping and Aggregation with groupby() 4m
- Review: groupby() 3m
- Demo: Structural Transformations with stack() and unstack() 3m
- Demo: Structural Transformations with pivot() and melt() 4m
- Review: Structural Transformations 5m
- Demo: Combining Datastructures 5m