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

Exercise

Get data from a spreadsheet

In this exercise, you'll create a dataframe from a "base case" Excel file: one with a single sheet of tabular data. The fcc_survey.xlsx file here has a sample of responses from FreeCodeCamp's annual New Developer Survey. This survey asks participants about their demographics, education, work and home life, plus questions about how they're learning to code. Let's load all of it.

pandas has not been pre-loaded in this exercise, so you'll need to import it yourself before using read_excel() to load the spreadsheet.

Instructions

100 XP
  • Load the pandas library as pd.
  • Read in fcc_survey.xlsx and assign it to the variable survey_responses.
  • Print the first few records of survey_responses.