You may already be familiar with the concept of pivot tables from Excel to quickly slice, filter, and group data in an efficient way. In the first part of this lab, you will use Pandas pivot table to extract insights from your data. In the second part of this lab you will learn to describe the strengh and direction of the relationship between two variables. Correlation analysis measures how two variables are related.

Open the main.ipynb file in the your-code directory. There are 3 exercises and in each exercise you will work with 3 different datasets. The datasets are in the same directory. Please keep in mind that you might also need to use some of the functions you saw in the previous lessons. Remember there is a common thread!!

• main.ipynb with your responses.

Upon completion, add your deliverables to git. Then commit git and push your branch to the remote.

Pandas Pivot Table

Correlation and Dependance

Google Search