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.
Bu egzersiz
Streamlined Data Ingestion with pandas
kursunun bir parçasıdırEgzersiz talimatları
- Load the
pandaslibrary aspd. - Read in
fcc_survey.xlsxand assign it to the variablesurvey_responses. - Print the first few records of
survey_responses.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
# Load pandas as pd
____
# Read spreadsheet and assign it to survey_responses
survey_responses = ____
# View the head of the dataframe
print(____)