In the Introduction to Pandas lesson, we learned about the two main data structures in Pandas (Series and DataFrames), how to work with them, how to obtain them from other data structures, and how to perform basic calculations with them.
The goal of this lab is to help you practice the concepts you learned in the lesson and provide you with some hands-on experience working with Pandas.
Now you should already be familiar with the workflow of solving and submitting the labs. But in case not, review the guidelines in the previous labs.
In this lab you will be working on main.ipynb. To launch it, first navigate to the directory that contains main.ipynb in Terminal, then execute jupyter notebook. In the webpage that is automatically opened, click the main.ipynb link to launch it.
When you are on main.ipynb, read the instructions for each cell and provide your answers. Make sure to test your answers in each cell and save. Jupyter Notebook should automatically save your work progress. But it's a good idea to periodically save your work manually just in case.
By the end of this lab, you will have learned how to import and export csv and Excel files.
main.ipynbwith your responses to each of the exercises.
Upon completion, add your deliverables to git. Then commit git and push your branch to the remote.