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.

Este ejercicio forma parte del curso

Importing and Managing Financial Data in Python

Ver curso

Instrucciones del ejercicio

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

Ejercicio interactivo práctico

Prueba este ejercicio y completa el código de muestra.

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

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

# Inspect the data
nyse.info()

Editar y ejecutar código