Please note, this is a STATIC archive of website www.w3resource.com from 19 Jul 2022, cach3.com does not collect or store any user information, there is no "phishing" involved.
w3resource

Pandas Plotting: Exercises, Practice, Solution

[An editor is available at the bottom of the page to write and execute the scripts.]

Pandas Plotting [19 exercises with solution]

Historical stock prices of Alphabet Inc. (GOOG)
Time Period: April 01, 2020 - October 01, 2020

alphabet_stock_data:


Description of Dataset:

  • Date: It gives the date of which stocks details are given.
  • Open: It gives the opening price of stock on that date.
  • High: It gives the highest price to which the stock ascened on that day.
  • Low: It gives the highest price to which the stock plummeted on that day.
  • Close: It gives the closing price of stock on that date.
  • Volume: It gives the amount of stock traded on that date.
  • Adjusted Close: An adjusted closing price is a stock’s closing price on any given day of trading that has been amended to include any distributions and corporate actions that occurred at any time prior to the next day’s open.

Click here to download alphabet_stock_data.csv

1. Write a Pandas program to create a line plot of the historical stock prices of Alphabet Inc. between two specific dates. Go to the editor
Click me to see the sample solution

2. Write a Pandas program to create a line plot of the opening, closing stock prices of Alphabet Inc. between two specific dates. Go to the editor
Click me to see the sample solution

3. Write a Pandas program to create a bar plot of the trading volume of Alphabet Inc. stock between two specific dates. Go to the editor
Click me to see the sample solution

4. Write a Pandas program to create a bar plot of opening, closing stock prices of Alphabet Inc. between two specific dates. Go to the editor
Click me to see the sample solution

5. Write a Pandas program to create a stacked bar plot of opening, closing stock prices of Alphabet Inc. between two specific dates. Go to the editor
Click me to see the sample solution

6. Write a Pandas program to create a horizontal stacked bar plot of opening, closing stock prices of Alphabet Inc. between two specific dates. Go to the editor
Click me to see the sample solution

7. Write a Pandas program to create a histograms plot of opening, closing, high, low stock prices of Alphabet Inc. between two specific dates. Go to the editor
Click me to see the sample solution

8. Write a Pandas program to create a stacked histograms plot of opening, closing, high, low stock prices of Alphabet Inc. between two specific dates. Go to the editor
Click me to see the sample solution

9. Write a Pandas program to draw a horizontal and cumulative histograms plot of opening stock prices of Alphabet Inc. between two specific dates. Go to the editor
Click me to see the sample solution

10. Write a Pandas program to create a stacked histograms plot of opening, closing, high, low stock prices of Alphabet Inc. between two specific dates with more bins. Go to the editor
Click me to see the sample solution

11. Write a Pandas program to create a stacked histograms plot with more bins of opening, closing, high, low stock prices of Alphabet Inc. between two specific dates. Go to the editor
Click me to see the sample solution

12. Write a Pandas program to create a plot of stock price and trading volume of Alphabet Inc. between two specific dates. Go to the editor
Click me to see the sample solution

13. Write a Pandas program to create a plot of Open, High, Low, Close, Adjusted Closing prices and Volume of Alphabet Inc. between two specific dates. Go to the editor
Click me to see the sample solution

14. Write a Pandas program to create a plot of adjusted closing prices, thirty days and forty days simple moving average of Alphabet Inc. between two specific dates. Go to the editor
Click me to see the sample solution

15. Write a Pandas program to create a plot of adjusted closing prices, 30 days simple moving average and exponential moving average of Alphabet Inc. between two specific dates. Go to the editor
Click me to see the sample solution

16. Write a Pandas program to create a scatter plot of the trading volume/stock prices of Alphabet Inc. stock between two specific dates. Go to the editor
Click me to see the sample solution

17. Write a Pandas program to create a plot to visualize daily percentage returns of Alphabet Inc. stock price between two specific dates. Go to the editor
Click me to see the sample solution

18. Write a Pandas program to plot the volatility over a period of time of Alphabet Inc. stock price between two specific dates. Go to the editor
Click me to see the sample solution

19. Write a Pandas program to create a histogram to visualize daily return distribution of Alphabet Inc. stock price between two specific dates. Go to the editor
Click me to see the sample solution

Python Code Editor:


More to Come !

Do not submit any solution of the above exercises at here, if you want to contribute go to the appropriate exercise page.

Test your Python skills with w3resource's quiz



Python: Tips of the Day

Find current directory and file's directory:

To get the full path to the directory a Python file is contained in, write this in that file:

import os 
dir_path = os.path.dirname(os.path.realpath(__file__))

(Note that the incantation above won't work if you've already used os.chdir() to change your current working directory, since the value of the __file__ constant is relative to the current working directory and is not changed by an os.chdir() call.)

To get the current working directory use

import os
cwd = os.getcwd()

Documentation references for the modules, constants and functions used above:

  • The os and os.path modules.
  • The __file__ constant
  • os.path.realpath(path) (returns "the canonical path of the specified filename, eliminating any symbolic links encountered in the path")
  • os.path.dirname(path) (returns "the directory name of pathname path")
  • os.getcwd() (returns "a string representing the current working directory")
  • os.chdir(path) ("change the current working directory to path")

Ref: https://bit.ly/3fy0R6m