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, sheet_name=0, na_values=None, ...)

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

This exercise is part of the course

Importing and Managing Financial Data in Python

View Course

Exercise instructions

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().

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# Import the data
nyse = pd.read_excel('listings.xlsx', ____, ____)

# Display the head of the data
print(nyse.head())

# Inspect the data
nyse.info()

Edit and Run Code