Session Ready
Exercise

Load listing info from a single sheet

As you just learned, you can import data from a sheet of an Excel file with the pd.read_excel() function by assigning the optional sheet_name argument to an integer indicating its position or a string containing its name.

pandas.read_excel(file, sheetname=0, na_values=None, ...)

Here, you will practice by importing NYSE data from a new file, listings.xlsx. pandas has been imported as pd.

Instructions
100 XP
  • Read only the 'nyse' worksheet of 'listings.xlsx' where the symbol 'n/a' represents missing values. Assign the result to nyse.
  • Display and inspect nyse with .head() and .info().
Loading