Load a portion of a spreadsheet

Spreadsheets meant to be read by people often have multiple tables, e.g., a small business might keep an inventory spreadsheet with tables for different product types on a single sheet. Even tabular data may have header rows of metadata, like the New Developer Survey data here. While the metadata is useful, we don't want it in a data frame. You'll use read_excel()'s skiprows keyword to get just the data. You'll also use usecols to focus on columns AD and AW through BA, about future job goals.

pandas has been imported as pd.

Create a string, col_string, specifying that pandas should load columns AD and the range AW through BA.
Load fcc_survey_headers.xlsx', setting skiprows and usecols to skip the first two rows of metadata and get only the columns in col_string.
View the selected column names in the resulting data frame.

Take Hint (-30 XP)

Exercise

Load a portion of a spreadsheet

Instructions