Jovian
⭐️
Sign In
1
NotebookFilesCollaborators
Version 12

Data Analysis with Python: Zero to Pandas - Course Project Guidelines

(remove this cell before submission)

Make submissions here: https://jovian.ml/learn/data-analysis-with-python-zero-to-pandas/assignment/course-project

This is the starter notebook for the course project for Data Analysis with Python: Zero to Pandas. For the course project, you will pick a real-world dataset of your choice and apply the concepts learned in this course to perform exploratory data analysis. Use this starter notebook as an outline for your project (you can also start with an empty new notebook). Focus on documentation and presentation - this Jupyter notebook will also serve as a project report, so make sure to include detailed explanations whererver possible using Markdown cells.

Step 1: Select a real-world dataset

  • Find and download an interesting real-world dataset (see the Recommended Datasets section below for ideas).

  • The dataset should contain tabular data (rowsn & columns), preferably in CSV/JSON/XLS or other formats that can be read using Pandas. If it's not in a compatible format, you may have to write some code to convert it to a desired format.

  • The dataset should contain at least 3 columns and 150 rows of data. You can also combine data from multiple sources to create a large enough dataset.

Step 2: Perform data preparation & cleaning
  • Load the dataset into a data frame using Pandas
  • Explore the number of rows & columns, ranges of values etc.
  • Handle missing, incorrect and invalid data
  • Perform any additional steps (parsing dates, creating additional columns, merging multiple dataset etc.)
Step 3: Perform exploratory Analysis & Visualization
  • Compute the mean, sum, range and other interesting statistics for numeric columns
  • Explore distributions of numeric columns using histograms etc.
  • Explore relationship between columns using scatter plots, bar charts etc.
  • Make a note of interesting insights from the exploratory analysis
Step 4: Ask & answer questions about the data
  • Ask at least 5 interesting questions about your dataset
  • Answer the questions either by computing the results using Numpy/Pandas or by plotting graphs using Matplotlib/Seaborn
  • Create new columns, merge multiple dataset and perform grouping/aggregation wherever necessary
  • Wherever you're using a library function from Pandas/Numpy/Matplotlib etc. explain briefly what it does
Step 5: Summarize your inferences & write a conclusion
  • Write a summary of what you've learned from the analysis
  • Include interesting insights and graphs from previous sections
  • Share ideas for future work on the same topic using other relevant datasets
  • Share links to resources you found useful during your analysis
Step 6: Make a submission & share your work
(Optional) Step 7: Write a blog post

Recommended Datasets

Use the following resources for finding interesting datasets:

Example Projects

Refer to these projects for inspiration:

Evaluation Criteria

Your submission will be evaluated using the following criteria:

  • Dataset must contain at least 3 columns and 150 rows of data
  • You must ask and answer at least 5 questions about the dataset
  • Your submission must include at least 5 visualizations (graphs)
  • Your submission must include explanations using markdown cells, apart from the code.
  • Your work must not be plagiarized i.e. copy-pasted for somewhere else.

NOTE: Remove this cell containing the instructions before making your submission. You can do using the "Edit > Delete Cells" menu option.

Project Title

Write some introduction about your project here: describe the dataset, where you got it from, what you're trying to do with it, and which tools & techniques you're using. You can also mention about the course, and what you've learned from it.

As a first step, let's upload our Jupyter notebook to Jovian.ml.

In [1]:
project_name = "zerotopandas-course-project-Pokemon"
In [2]:
!pip install jovian --upgrade -q
In [3]:
import jovian
In [4]:
jovian.commit(project=project_name)
[jovian] Attempting to save notebook.. [jovian] Updating notebook "multiplexpcr/zerotopandas-course-project-pokemon" on https://jovian.ml/ [jovian] Uploading notebook.. [jovian] Capturing environment.. [jovian] Committed successfully! https://jovian.ml/multiplexpcr/zerotopandas-course-project-pokemon
Out[4]:
'https://jovian.ml/multiplexpcr/zerotopandas-course-project-pokemon'

Data Preparation and Cleaning

TODO

In [5]:
import pandas as pd
In [6]:
Pokemon = pd.read_csv('Pokemon.csv')
In [7]:
Pokemon.head()
Out[7]:
In [8]:
Pokemon.shape
Out[8]:
(800, 13)
In [9]:
Pokemon['Name'] = Pokemon['Name'].str.replace(".*(?=Mega)", "")
Pokemon.head()
Out[9]:
In [10]:
Pokemon= Pokemon.set_index('Name')
In [11]:
Pokemon.head()
Out[11]:
In [12]:
jovian.commit()
[jovian] Attempting to save notebook.. [jovian] Updating notebook "multiplexpcr/zerotopandas-course-project-pokemon" on https://jovian.ml/ [jovian] Uploading notebook.. [jovian] Capturing environment.. [jovian] Committed successfully! https://jovian.ml/multiplexpcr/zerotopandas-course-project-pokemon
Out[12]:
'https://jovian.ml/multiplexpcr/zerotopandas-course-project-pokemon'

Exploratory Analysis and Visualization

TODO

In [13]:
Number_of_Pokemon= Pokemon.shape[0]
In [14]:
print('There are {} Pokemon in this dataset.'.format(Number_of_Pokemon))
There are 800 Pokemon in this dataset.
In [15]:
Pokemon.describe()
Out[15]:
In [16]:
Pokemon['Type 1'].unique()
Out[16]:
array(['Grass', 'Fire', 'Water', 'Bug', 'Normal', 'Poison', 'Electric',
       'Ground', 'Fairy', 'Fighting', 'Psychic', 'Rock', 'Ghost', 'Ice',
       'Dragon', 'Dark', 'Steel', 'Flying'], dtype=object)
In [17]:
Pokemon['Generation'].unique()
Out[17]:
array([1, 2, 3, 4, 5, 6], dtype=int64)
In [ ]:
In [ ]:
jovian.commit()
[jovian] Attempting to save notebook..

Asking and Answering Questions

TODO

In [ ]:
In [ ]:
In [ ]:
In [ ]:
In [ ]:
In [ ]:
In [ ]:
In [ ]:
In [ ]:
jovian.commit()

Inferences and Conclusion

TODO

In [ ]:
In [ ]:
In [ ]:
In [ ]:
In [ ]:
jovian.commit()

References and Future Work

TODO

In [ ]:
In [ ]:
jovian.commit()
In [ ]: