1. Learn
    2. /
  2. Courses
    3. /
  3. Manipulating Time Series Data in Python

Exercise

Create time series of market value

You can now use the number of shares to calculate the total market capitalization for each component and trading date from the historical price series.

The result will be the key input to construct the value-weighted stock index, which you will complete in the next exercise.

Instructions

100 XP

We have already imported pandas as pd and matplotlib.pyplot as plt for you. We have also created the variables components and stock_prices that you worked with in the last exercises.

  • Select the 'Number of Shares' from components, assign to no_shares, and print the result, sorted in the default (ascending) order.
  • Multiply stock_prices by no_shares to create a time series of market cap per ticker, and assign it to market_cap.
  • Select the first and the last row of market_cap and assign these to first_value and last_value.
  • Use pd.concat() to concatenate first_value and last_value along axis=1 and plot the result as horizontal bar chart.