In this chapter, you will learn how to import, clean and combine data from Excel workbook sheets into a pandas DataFrame. You will also practice grouping data, summarizing information for categories, and visualizing the result using subplots and heatmaps.
You will use data on companies listed on the stock exchanges NASDAQ, NYSE, and AMEX with information on company name, stock symbol, last market capitalization and price, sector or industry group, and IPO year. In Chapter 2, you will build on this data to download and analyze stock price history for some of these companies.
Exercise 1: Reading, inspecting, and cleaning data from CSVExercise 2: Import stock listing info from the NASDAQExercise 3: How to fix the data import?Exercise 4: Read data using .read_csv() with adequate parsing argumentsExercise 5: Read data from Excel worksheetsExercise 6: Load listing info from a single sheetExercise 7: Load listing data from two sheetsExercise 8: Combine data from multiple worksheetsExercise 9: Load all listing data and iterate over key-value dictionary pairsExercise 10: How many companies are listed on the NYSE and NASDAQ?Exercise 11: Automate the loading and combining of data from multiple Excel worksheets