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

Python: Kwargs

**kwargs and *args are function arguments that can be very useful.

They are quite underused and often under-understood as well.

Let's try to explain what kwargs are and how to use them.

  • While *args are used to pass arguments at an unknown amount to functions, **kwargs are used to do the same but with named arguments.
  • So, if *args is a list being passed as an argument, you can think of **kwargs as a dictionary that's being passed as an argument to a function.
  • You can use arguments as you wish as long as you follow the correct order which is: arg1, arg2, *args, **kwargs. It's okay to use only one of those but you can't mix the order, for instance, you can't have: function(**kwargs, arg1), that'd be a major faux pas in Python.
  • Another example: You can do function(*args,**kwargs) since it follows the correct order.
  • Here is an example. Let's say satelites are given with their names and weight in tons in dictionary format. Code prints their weight as kilograms along with their names.
def payloads(**kwargs):
    for key, value in kwargs.items():
        print( key+" |||", float(value)*100)
payloads(NavSat1 = '2.5', BaysatG2 = '4')

Output:

NavSat1 ||| 250.0
BaysatG2 ||| 400.0

Since the function above would work for any number of dictionary keys, **kwargs makes perfect sense rather than passing arguments with a fixed amount.

def payloads(**kwargs):
    for key, value in kwargs.items():
        print( key+" |||", float(value)*100)

sats={"Tx211":"3", "V1":"0.50"}
payloads(**sats)

Output:

Tx211 ||| 300.0
V1 ||| 50.0