Exercises

Solve the following exercises using what we have learned so far in this book and the stock data in the exercises/ directory:

1. We want to look at data for the Facebook, Apple, Amazon, Netflix, and Google (FAANG) stocks, but we were given each as a separate CSV file (obtained using the stock_analysis package we will build in Chapter 7, Financial Analysis – Bitcoin and the Stock Market). Combine them into a single file and store the dataframe of the FAANG data as faang for the rest of the exercises:
   1. Read each file in.
   2. Add a column to each dataframe, called ticker, indicating the ticker symbol it is for (Apple's is AAPL, for example). This is how you look up a stock. Each file's name is also the ticker symbol, so be sure to capitalize it.
   3. Append them together into a single dataframe.
   4. Save the result in a CSV file called faang.csv.

2. With faang, use type...