Work with multiple spreadsheets

Workbooks meant primarily for human readers, not machines, may store data about a single subject across multiple sheets. For example, a file may have a different sheet of transactions for each region or year in which a business operated.

The FreeCodeCamp New Developer Survey file is set up similarly, with samples of responses from different years in different sheets. Your task here is to compile them in one data frame for analysis.

pandas has been imported as pd. All sheets have been read into the ordered dictionary responses, where sheet names are keys and data frames are values, so you can get data frames with the values() method.

Create an empty data frame, all_responses.
Set up a for loop to iterate through the values in the responses dictionary.
Append each data frame to all_responses and reassign the result to the same variable name.

Exercise

Work with multiple spreadsheets

Instructions