1. Learn
    2. /
  2. Courses
    3. /
  3. Streamlined Data Ingestion with pandas

Exercise

Select multiple sheets

So far, you've read Excel files one sheet at a time, which lets you customize import arguments for each sheet. But if an Excel file has some sheets that you want loaded with the same parameters, you can get them in one go by passing a list of their names or indices to read_excel()'s sheet_name keyword. To get them all, pass None. You'll practice both methods to get data from fcc_survey.xlsx, which has multiple sheets of similarly-formatted data.

pandas has been loaded as pd.

Instructions 1/3

undefined XP
  • 1

    Load both the 2016 and 2017 sheets by name with a list and one call to read_excel().

  • 2

    Load the 2016 sheet by its position (0) and 2017 by name. Note the sheet names in the result.

  • 3

    Load all sheets in the Excel file without listing them all.