- SQL ๐
- APIs ๐ก
- Pandas ๐ผ
For this review, please deliver the following:
-
A dataframe containing all stock prices for 2017.
- Please report if any columns have null values.
- Drop any null values from this dataframe.
-
Find the top ten single day stock increases in 2017.
-
A plot showing how many observations in the data occur on a US public holiday.
- Please print the names of the public holidays that are found within the dataset.
-
A statement clarifying whether or not the
BDX
stock rose or fell on Veterans day of 2017.- Please state what the opening and closing price for the stock was on Veterans day, and by how much it changed.
-
A subplot containing two graphs.
- Plot 1: The top ten stock price declines on veterans day of 2017
- Plot 2: The top ten stock price increases on veterans day of 2017
Please ensure every plot has a contextualizing title
You have been given a database called stocks.db
within the data/ folder of this repo.
- This database contains the opening and closing prices for the S&P 500 from 2013-2018.
For data on public holidays, you are to use The Public Holidays API which provides public holiday information for approximately 90 countries.
The documentation for this API can be found here
By combining data from these two sources, you will have the data required to complete the above tasks.
Sections have been provided to offer some guidance and structure as you work through this problem.
# Your work goes here
# Feel free to add more cells!
# Your work goes here
# Feel free to add more cells!
In the cell below, Find the top ten single day stock increases and visualize the results as a sorted bar plot.
The visualization should look something like this:
# Your work goes here
# Feel free to add more cells!
# Your work here!
# Your work here!
# Your code here
Please create a code cell below to meet this task