Get data from CSVs
In this exercise, you'll create a dataframe from a CSV file. The United States makes available CSV files containing tax data by ZIP or postal code, allowing us to analyze income information in different parts of the country. We'll focus on a subset of the data, vt_tax_data_2016.csv
, which has select tax statistics by ZIP code in Vermont in 2016.
To load the data, you'll need to import the pandas
library, then read vt_tax_data_2016.csv
and assign the resulting dataframe to a variable. Then we'll have a look at the data.
This exercise is part of the course
Streamlined Data Ingestion with pandas
Exercise instructions
- Import the
pandas
library aspd
. - Use
read_csv()
to loadvt_tax_data_2016.csv
and assign it to the variabledata
. - View the first few lines of the dataframe with the
head()
method. This code has been written for you.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Import pandas as pd
import ____ as pd
# Read the CSV and assign it to the variable data
data = ____(____)
# View the first few lines of data
print(data.head())