1. Learn
    2. /
  2. Courses
    3. /
  3. Analyzing US Census Data in Python

Exercise

Home Values in California

California's major cities have been in the news for skyrocketing housing prices. How has the median home value changed over the last several years? In this exercise you will use a loop to request variable B25077_001E from seven ACS years and plot the value over time.

The predicates dictionary has been created, and is printed to the console. Notice that state:06 sets the GEOID for California. pandas and seaborn have been imported using the usual aliases. HOST and dataset have been defined, and dfs is an empty list that has been initialized as a collector for the requested DataFrames.

Instructions

100 XP
  • Construct a range object with integers from 2011 to 2017
  • Create a column named "year", with its value set to the current value of the year variable
  • Set the median_home_value column data type to int
  • Create a lineplot of home values. Set the first parameter (x) to "year", set second parameter (y) to "median_home_value"