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 exercício faz parte do curso
Importing and Managing Financial Data in Python
Instruções do exercício
- Read only the
'nyse'worksheet of'listings.xlsx'where the symbol'n/a'represents missing values. Assign the result tonyse. - Display and inspect
nysewith.head()and.info().
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
# Import the data
nyse = pd.read_excel('listings.xlsx', ____, ____)
# Display the head of the data
print(nyse.head())
# Inspect the data
nyse.info()