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

Exercise

API to Visualization: Group Quarters

In this exercise, you will investigate where juvenile offenders are incarcerated. This exercise introduces the concept of "group quarters" populations, which includes college dorms, correctional facilities, nursing homes, military bases, etc.

You will visualize the percentage, by state, of incarcerated minor males in adult correctional facilities. The variables to request are:

  • PCT021005 - Male: Under 18 years: Institutionalized population: Correctional facilities for adults
  • PCT021015 - Male: Under 18 years: Institutionalized population: Juvenile facilities: Correctional facilities intended for juveniles

requests has been imported. The base_url for the API request has been defined.

pandas and seaborn have been imported using the usual aliases.

Instructions

100 XP
  • Complete the list get_vars with the two desired variables
  • Use astype to convert the columns in_adult and in_juvenile to integer
  • Calculate the percentage of minors in correctional facilities for adults: the numerator should be 100 times the number of minors in_adult correctional facilities; the denominator should be the sum of minors in_adult and in_juvenile correctional facilities
  • Sort states by pct_in_adult in descending order, using inplace = True