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

Exercise

Preparing data for a facet grid plot

In this exercise, you will prepare the data to make this plot: This plot shows the gross margin of tech companies, FMCG companies, the average tech company, and the average FMCG companies over many years. In the next exercise, you'll practice making the plot. This is a neat plot to observe:

  • The gross margin of tech companies is more spread out than those of FMCG companies
  • Year by year, how profitable a company is compared to the average company in its industry.

pandas is loaded with the alias pd and seaborn is loaded with the alias sns. A pandas DataFrame dataset is loaded for you which already has a gross_margin column computed.

Instructions 1/3

undefined XP
    1
    2
    3
  • Make a DataFrame with only tech and FMCG companies; you can subset "tech" and "fmcg" companies from the column "comp_type" in the DataFrame dataset.