Assignment 3 - Pandas Data Analysis Practice

This assignment is a part of the course "Data Analysis with Python: Zero to Pandas"

In this assignment, you'll get to practice some of the concepts and skills covered in this tutorial: https://jovian.ai/aakashns/python-pandas-data-analysis

As you go through this notebook, you will find a ??? in certain places. To complete this assignment, you must replace all the ??? with appropriate values, expressions or statements to ensure that the notebook runs properly end-to-end.

Some things to keep in mind:

Make sure to run all the code cells, otherwise you may get errors like NameError for undefined variables.
Do not change variable names, delete cells or disturb other existing code. It may cause problems during evaluation.
In some cases, you may need to add some code cells or new statements before or after the line of code containing the ???.
Since you'll be using a temporary online service for code execution, save your work by running jovian.commit at regular intervals.
Questions marked (Optional) will not be considered for evaluation, and can be skipped. They are for your learning.

You can make submissions on this page: https://jovian.ai/learn/data-analysis-with-python-zero-to-pandas/assignment/assignment-3-pandas-practice

If you are stuck, you can ask for help on the community forum: https://jovian.ai/forum/t/assignment-3-pandas-practice/11225/3. You can get help with errors or ask for hints, describe your approach in simple words, link to documentation, but please don't ask for or share the full working answer code on the forum.

How to run the code and save your work

The recommended way to run this notebook is to click the "Run" button at the top of this page, and select "Run on Binder". This will run the notebook on mybinder.org, a free online service for running Jupyter notebooks.

Before starting the assignment, let's save a snapshot of the assignment to your Jovian.ai profile, so that you can access it later, and continue your work.

import jovian

jovian.commit()

[jovian] Error: Failed to read the Jupyter notebook. Please re-run this cell to try again. If the issue persists, provide the "filename" argument to "jovian.commit" e.g. "jovian.commit(filename='my-notebook.ipynb')"

jovian()

jovian.commit(filename='pandas-practice-assignment', environment=None)

---------------------------------------------------------------------------
UnboundLocalError                         Traceback (most recent call last)
Input In [54], in <module>
----> 1 jovian.commit(filename='pandas-practice-assignment', environment=None)

File ~\anaconda3\envs\data\lib\site-packages\jovian\utils\commit.py:196, in commit(message, files, outputs, environment, privacy, filename, project, new_project, git_commit, git_message, **kwargs)
    193     return
    195 # Retrieve Gist ID & title
--> 196 project_title, project_id = _parse_project(project, filename, new_project)
    198 # Create or update gist (with title and )
    199 res = api.create_gist_simple(filename, project_id, privacy, project_title, message)

File ~\anaconda3\envs\data\lib\site-packages\jovian\utils\commit.py:300, in _parse_project(project, filename, new_project)
    298 # Skip if metadata could not be found
    299 if not metadata:
--> 300     log('Creating a new project "' + username + '/' + project_title + '"')
    301     return project_title, None
    303 # Extract information from metadata

UnboundLocalError: local variable 'username' referenced before assignment