1. Learn
    2. /
  2. Courses
    3. /
  3. Analyzing Financial Statements in Python
Connected

Exercise

Using margins in pivot tables and making a bar plot

You just learned the margins functionality of pivot_table().

Setting margins = True while using pivot_table() returns the aggfunc of the whole value, i.e., is the aggfunc of the value not conditioned on its index.

In this exercise, you will practice what you've learned. You will make a plot where you prepare the data using pivot_table() and also make use of the margins functionality.

A pandas DataFrame called dataset has been loaded for you. pandas and Seaborn have been loaded with the aliases pd and sns respectively.

Instructions 1/3

undefined XP
    1
    2
    3
  • Print the columns of dataset to identify the ones you need to compute the debt-to-equity ratio.