1. Learn
    2. /
  2. Courses
    3. /
  3. Importing and Managing Financial Data in Python

Exercise

Load all listing data and iterate over key-value dictionary pairs

You already know that a pd.DataFrame() object is a two-dimensional labeled data structure. As you saw in the video, the pd.concat() function is used to concatenate, or vertically combine, two or more DataFrames. You can also use broadcasting to add new columns to DataFrames.

In this exercise, you will practice using this new pandas function with the data from the NYSE and NASDAQ exchanges. pandas has been imported as pd.

Instructions

100 XP
  • Import data in listings.xlsx from sheets 'nyse' and 'nasdaq' into the variables nyse and nasdaq. Read 'n/a' to represent missing values.
  • Inspect the contents of both DataFrames with .info() to find out how many companies are reported.
  • With broadcasting, create a new reference column called 'Exchange' holding the values 'NYSE' or 'NASDAQ' for each DataFrame.
  • Use pd.concat() to concatenate the nyse and nasdaq DataFrames, in that order, and assign to combined_listings.