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

Exercise

Select a single sheet

An Excel workbook may contain multiple sheets of related data. The New Developer Survey response workbook has sheets for different years. Because read_excel() loads only the first sheet by default, you've already gotten survey responses for 2016. Now, you'll create a dataframe of 2017 responses using read_excel()'s sheet_name argument in a couple different ways.

pandas has been imported as pd.

Instructions 1/2

undefined XP
  • 1

    Create a dataframe from the second workbook sheet by passing the sheet's position to sheet_name.

  • 2

    Create a dataframe from the 2017 sheet by providing the sheet's name to read_excel().