1. Learn
    2. /
  2. Courses
    3. /
  3. Importing and Managing Financial Data in Python

Exercise

Company value by exchange and sector

You can generate more fine-grained summaries of your data by providing a list of columns inside .groupby() and/or applying a statistical method such as .mean() directly to one or more numerical columns.

Here, you will calculate the median market capitalization for each sector, differentiated by the exchange that the companies are listed on. You will also use .unstack() to pivot the exchange labels from the rows into the columns. It's a good idea to inspect listings in your console before starting the exercise!

pandas as pd and matplotlib.pyplot as plt have been imported, and the listings DataFrame, with reference column 'Exchange' and a new column market_cap_m that contains the market cap in millions of USD, is available in your workspace.

Instructions

100 XP
  • Group your data by both 'Sector' and 'Exchange', assigning the result to by_sector_exchange.
  • Calculate the median market capitalization for by_sector_exchange and assign to mcap_by_sector_exchange.
  • Display the first 5 rows of the result with .head().
  • Call .unstack() on mcap_by_sector_exchange to move the Exchange labels to the columns, and assign to mcap_unstacked.
  • Plot the result as a bar chart with the title 'Median Market Capitalization by Exchange' and ylabel set to 'USD mn',
  • Show the result.