Learn practical skills, build real-world projects, and advance your career

Project Title - Stock Analysis for Amazon & Google

We will download the FAANG Stock Dataset from Kaggle, which contains the stock market data for Facebook, Apple, Amazon, Netflix and Google for the past 15-20 years. We will specifically use only two datasets, they are Amazon.csv and Google.csv.

Both the datasets contain the Date, Open, Close, High, Low, Adjusted Close, Year and Volume traded. The dataset has around 5000 records and the second dataset has around 4500 records.

We will use the python libraries - numpy and pandas for data preparation and cleaning and we will use the matplotlib and seaborn libaries for visualising the data in various graphs and plots.

The data analysis course - Data Analysis with Python: Zero to Pandas (zerotopandas.com) provided the necessary knowledge to complete this project.

How to run the code

This is an executable Jupyter notebook hosted on Jovian.ml, a platform for sharing data science projects. You can run and experiment with the code in a couple of ways: using free online resources (recommended) or on your own computer.

Option 1: Running using free online resources (1-click, recommended)

The easiest way to start executing 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. You can also select "Run on Colab" or "Run on Kaggle".

Option 2: Running on your computer locally
  1. Install Conda by following these instructions. Add Conda binaries to your system PATH, so you can use the conda command on your terminal.

  2. Create a Conda environment and install the required libraries by running these commands on the terminal:

conda create -n zerotopandas -y python=3.8 
conda activate zerotopandas
pip install jovian jupyter numpy pandas matplotlib seaborn opendatasets --upgrade
  1. Press the "Clone" button above to copy the command for downloading the notebook, and run it on the terminal. This will create a new directory and download the notebook. The command will look something like this:
jovian clone notebook-owner/notebook-id
  1. Enter the newly created directory using cd directory-name and start the Jupyter notebook.
jupyter notebook

You can now access Jupyter's web interface by clicking the link that shows up on the terminal or by visiting http://localhost:8888 on your browser. Click on the notebook file (it has a .ipynb extension) to open it.

Downloading the Dataset

We will download the FAANG Stock Dataset from Kaggle, which contains the stock market data for Facebook, Apple, Amazon, Netflix and Google for the past 15-20 years. We will specifically use only two datasets, they are Amazon.csv and Google.csv.

!pip install jovian opendatasets --upgrade --quiet
'pip' is not recognized as an internal or external command, operable program or batch file.

Let's begin by downloading the data, and listing the files within the dataset.