Get the largest consumer company listed after 1998

Google Finance has deprecated their API but DataReader now makes available instead the data source 'iex'. To experiment with the data outside DataCamp environment, you will need an IEX Cloud account.

The functionality using 'iex' is the same except: data is limited to the last five years, column headers are lower case.

You can filter your data by even more conditions by enclosing each condition in parentheses and using logical operators like & and |.

Here, you will find out which company is the largest consumer services company that went public after Amazon did in 1997. The data is contained in the column 'IPO Year'; an Initial Public Offering (IPO) is a financial term that describes the first time that the stock of a private company is offered to the public.

DataReader, date, pandas as pd, and matplotlib.pyplot as plt have been imported. The listings DataFrame from the last exercise is also available.

Set 'Stock Symbol' as the index for listings.
Use .loc[] to filter rows where 'Sector' is 'Consumer Services' and IPO Year starting 1998, and also select the 'Market Capitalization' column. Apply .idxmax() and assign the result to ticker.
Set the start date to January 1, 2015.
Use the DataReader to get the stock data for the ticker from 'iex' since start.
Plot the 'close' and 'volume' prices of this company, using 'volume' for secondary_y and ticker as the title.

Exercise

Get the largest consumer company listed after 1998

Instructions