As a first example, let's suppose we're interested in unemployment and high school dropout rates for block groups in Cook County, Illinois, which contains Chicago, IL.
We begin by importing the censusdata and pandas modules, and setting some display options in pandas for nicer output:
In [1]:
import pandas as pd
import censusdata
pd.set_option('display.expand_frame_repr', False)
pd.set_option('display.precision', 2)
To download data, we need to identify the relevant tables containing the variables of interest to us.
One way to do this would be to refer to the ACS documentation, in particular the Table Shells
(https://www.census.gov/programs-surveys/acs/technical-documentation/summary-file-documentation.html). Alternatively, it is possible to do this from within Python. censusdata.search will search for given text patterns. The downside to this is output can be voluminous, as in the following searches, as ACS frequently provides a large number of different tabulations related to a given topic area. Below, we limit the output to the relevant variables:
In [2]:
censusdata.search('acs5', 2015, 'label', 'unemploy')[160:170]
Out[2]:
[('B23024_023E',
'B23024. Poverty Status in the Past 12 Months by Disability Status by Employment Status for the Population 20 to 64 Years',
'Income in the past 12 months at or above poverty level:!!With a disability:!!In labor force:!!Civilian:!!Unemployed'),
('B23024_023M',
'B23024. Poverty Status in the Past 12 Months by Disability Status by Employment Status for the Population 20 to 64 Years',
'Margin of Error for!!Income in the past 12 months at or above poverty level:!!With a disability:!!In labor force:!!Civilian:!!Unemployed'),
('B23024_030E',
'B23024. Poverty Status in the Past 12 Months by Disability Status by Employment Status for the Population 20 to 64 Years',
'Income in the past 12 months at or above poverty level:!!No disability:!!In labor force:!!Civilian:!!Unemployed'),
('B23024_030M',
'B23024. Poverty Status in the Past 12 Months by Disability Status by Employment Status for the Population 20 to 64 Years',
'Margin of Error for!!Income in the past 12 months at or above poverty level:!!No disability:!!In labor force:!!Civilian:!!Unemployed'),
('B23025_005E',
'B23025. Employment Status for the Population 16 Years and Over',
'In labor force:!!Civilian labor force:!!Unemployed'),
('B23025_005M',
'B23025. Employment Status for the Population 16 Years and Over',
'Margin Of Error For!!In labor force:!!Civilian labor force:!!Unemployed'),
('B27011_014E',
'B27011. Health Insurance Coverage Status and Type by Employment Status by Age',
'In labor force:!!Unemployed:'),
('B27011_014M',
'B27011. Health Insurance Coverage Status and Type by Employment Status by Age',
'Margin of Error for!!In labor force:!!Unemployed:'),
('B27011_015E',
'B27011. Health Insurance Coverage Status and Type by Employment Status by Age',
'In labor force:!!Unemployed:!!18 to 64 years:'),
('B27011_015M',
'B27011. Health Insurance Coverage Status and Type by Employment Status by Age',
'Margin of Error for!!In labor force:!!Unemployed:!!18 to 64 years:')]
In [3]:
censusdata.search('acs5', 2015, 'concept', 'education')[730:790]
Out[3]:
[('B15002_035E',
'B15002. Sex by Educational Attainment for the Population 25 Years and over',
'Female:!!Doctorate degree'),
('B15002_035M',
'B15002. Sex by Educational Attainment for the Population 25 Years and over',
'Margin of Error for!!Female:!!Doctorate degree'),
('B15003_001E',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Total:'),
('B15003_001M',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Margin of Error for!!Total:'),
('B15003_002E',
'B15003. Educational Attainment for the Population 25 Years and Over',
'No schooling completed'),
('B15003_002M',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Margin of Error for!!No schooling completed'),
('B15003_003E',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Nursery school'),
('B15003_003M',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Margin of Error for!!Nursery school'),
('B15003_004E',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Kindergarten'),
('B15003_004M',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Margin of Error for!!Kindergarten'),
('B15003_005E',
'B15003. Educational Attainment for the Population 25 Years and Over',
'1st grade'),
('B15003_005M',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Margin of Error for!!1st grade'),
('B15003_006E',
'B15003. Educational Attainment for the Population 25 Years and Over',
'2nd grade'),
('B15003_006M',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Margin of Error for!!2nd grade'),
('B15003_007E',
'B15003. Educational Attainment for the Population 25 Years and Over',
'3rd grade'),
('B15003_007M',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Margin of Error for!!3rd grade'),
('B15003_008E',
'B15003. Educational Attainment for the Population 25 Years and Over',
'4th grade'),
('B15003_008M',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Margin of Error for!!4th grade'),
('B15003_009E',
'B15003. Educational Attainment for the Population 25 Years and Over',
'5th grade'),
('B15003_009M',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Margin of Error for!!5th grade'),
('B15003_010E',
'B15003. Educational Attainment for the Population 25 Years and Over',
'6th grade'),
('B15003_010M',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Margin of Error for!!6th grade'),
('B15003_011E',
'B15003. Educational Attainment for the Population 25 Years and Over',
'7th grade'),
('B15003_011M',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Margin of Error for!!7th grade'),
('B15003_012E',
'B15003. Educational Attainment for the Population 25 Years and Over',
'8th grade'),
('B15003_012M',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Margin of Error for!!8th grade'),
('B15003_013E',
'B15003. Educational Attainment for the Population 25 Years and Over',
'9th grade'),
('B15003_013M',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Margin of Error for!!9th grade'),
('B15003_014E',
'B15003. Educational Attainment for the Population 25 Years and Over',
'10th grade'),
('B15003_014M',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Margin of Error for!!10th grade'),
('B15003_015E',
'B15003. Educational Attainment for the Population 25 Years and Over',
'11th grade'),
('B15003_015M',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Margin of Error for!!11th grade'),
('B15003_016E',
'B15003. Educational Attainment for the Population 25 Years and Over',
'12th grade, no diploma'),
('B15003_016M',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Margin of Error for!!12th grade, no diploma'),
('B15003_017E',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Regular high school diploma'),
('B15003_017M',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Margin of Error for!!Regular high school diploma'),
('B15003_018E',
'B15003. Educational Attainment for the Population 25 Years and Over',
'GED or alternative credential'),
('B15003_018M',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Margin of Error for!!GED or alternative credential'),
('B15003_019E',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Some college, less than 1 year'),
('B15003_019M',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Margin of Error for!!Some college, less than 1 year'),
('B15003_020E',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Some college, 1 or more years, no degree'),
('B15003_020M',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Margin of Error for!!Some college, 1 or more years, no degree'),
('B15003_021E',
'B15003. Educational Attainment for the Population 25 Years and Over',
"Associate's degree"),
('B15003_021M',
'B15003. Educational Attainment for the Population 25 Years and Over',
"Margin of Error for!!Associate's degree"),
('B15003_022E',
'B15003. Educational Attainment for the Population 25 Years and Over',
"Bachelor's degree"),
('B15003_022M',
'B15003. Educational Attainment for the Population 25 Years and Over',
"Margin of Error for!!Bachelor's degree"),
('B15003_023E',
'B15003. Educational Attainment for the Population 25 Years and Over',
"Master's degree"),
('B15003_023M',
'B15003. Educational Attainment for the Population 25 Years and Over',
"Margin of Error for!!Master's degree"),
('B15003_024E',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Professional school degree'),
('B15003_024M',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Margin of Error for!!Professional school degree'),
('B15003_025E',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Doctorate degree'),
('B15003_025M',
'B15003. Educational Attainment for the Population 25 Years and Over',
'Margin of Error for!!Doctorate degree'),
('B16010_001E',
'B16010. EDUCATIONAL ATTAINMENT AND EMPLOYMENT STATUS BY LANGUAGE SPOKEN AT HOME FOR THE POPULATION 25 YEARS AND OVER',
'Total:'),
('B16010_001M',
'B16010. EDUCATIONAL ATTAINMENT AND EMPLOYMENT STATUS BY LANGUAGE SPOKEN AT HOME FOR THE POPULATION 25 YEARS AND OVER',
'Margin Of Error For!!Total:'),
('B16010_002E',
'B16010. EDUCATIONAL ATTAINMENT AND EMPLOYMENT STATUS BY LANGUAGE SPOKEN AT HOME FOR THE POPULATION 25 YEARS AND OVER',
'Less than high school graduate:'),
('B16010_002M',
'B16010. EDUCATIONAL ATTAINMENT AND EMPLOYMENT STATUS BY LANGUAGE SPOKEN AT HOME FOR THE POPULATION 25 YEARS AND OVER',
'Margin Of Error For!!Less than high school graduate:'),
('B16010_003E',
'B16010. EDUCATIONAL ATTAINMENT AND EMPLOYMENT STATUS BY LANGUAGE SPOKEN AT HOME FOR THE POPULATION 25 YEARS AND OVER',
'Less than high school graduate:!!In labor force:'),
('B16010_003M',
'B16010. EDUCATIONAL ATTAINMENT AND EMPLOYMENT STATUS BY LANGUAGE SPOKEN AT HOME FOR THE POPULATION 25 YEARS AND OVER',
'Margin Of Error For!!Less than high school graduate:!!In labor force:'),
('B16010_004E',
'B16010. EDUCATIONAL ATTAINMENT AND EMPLOYMENT STATUS BY LANGUAGE SPOKEN AT HOME FOR THE POPULATION 25 YEARS AND OVER',
'Less than high school graduate:!!In labor force:!!Speak only English'),
('B16010_004M',
'B16010. EDUCATIONAL ATTAINMENT AND EMPLOYMENT STATUS BY LANGUAGE SPOKEN AT HOME FOR THE POPULATION 25 YEARS AND OVER',
'Margin Of Error For!!Less than high school graduate:!!In labor force:!!Speak only English')]
(Please note that searching Census variables and printing out a single table rely on previously downloaded information from the Census API, because otherwise every time we did this we would have to download data for all variables.) Once we have identified a table of interest, we can use censusdata.printtable to show all variables
included in the table:
In [4]:
censusdata.printtable(censusdata.censustable('acs5', 2015, 'B23025'))
Variable | Table | Label | Type
-------------------------------------------------------------------------------------------------------------------
B23025_001E | B23025. Employment Status for | Total: | int
B23025_002E | B23025. Employment Status for | In labor force: | int
B23025_003E | B23025. Employment Status for | !! In labor force: Civilian labor force: | int
B23025_004E | B23025. Employment Status for | !! !! In labor force: Civilian labor force: Employed | int
B23025_005E | B23025. Employment Status for | !! !! In labor force: Civilian labor force: Unemployed | int
B23025_006E | B23025. Employment Status for | !! In labor force: Armed Forces | int
B23025_007E | B23025. Employment Status for | Not in labor force | int
-------------------------------------------------------------------------------------------------------------------
In [5]:
censusdata.printtable(censusdata.censustable('acs5', 2015, 'B15003'))
Variable | Table | Label | Type
-------------------------------------------------------------------------------------------------------------------
B15003_001E | B15003. Educational Attainmen | Total: | int
B15003_002E | B15003. Educational Attainmen | No schooling completed | int
B15003_003E | B15003. Educational Attainmen | Nursery school | int
B15003_004E | B15003. Educational Attainmen | Kindergarten | int
B15003_005E | B15003. Educational Attainmen | 1st grade | int
B15003_006E | B15003. Educational Attainmen | 2nd grade | int
B15003_007E | B15003. Educational Attainmen | 3rd grade | int
B15003_008E | B15003. Educational Attainmen | 4th grade | int
B15003_009E | B15003. Educational Attainmen | 5th grade | int
B15003_010E | B15003. Educational Attainmen | 6th grade | int
B15003_011E | B15003. Educational Attainmen | 7th grade | int
B15003_012E | B15003. Educational Attainmen | 8th grade | int
B15003_013E | B15003. Educational Attainmen | 9th grade | int
B15003_014E | B15003. Educational Attainmen | 10th grade | int
B15003_015E | B15003. Educational Attainmen | 11th grade | int
B15003_016E | B15003. Educational Attainmen | 12th grade, no diploma | int
B15003_017E | B15003. Educational Attainmen | Regular high school diploma | int
B15003_018E | B15003. Educational Attainmen | GED or alternative credential | int
B15003_019E | B15003. Educational Attainmen | Some college, less than 1 year | int
B15003_020E | B15003. Educational Attainmen | Some college, 1 or more years, no degree | int
B15003_021E | B15003. Educational Attainmen | Associate's degree | int
B15003_022E | B15003. Educational Attainmen | Bachelor's degree | int
B15003_023E | B15003. Educational Attainmen | Master's degree | int
B15003_024E | B15003. Educational Attainmen | Professional school degree | int
B15003_025E | B15003. Educational Attainmen | Doctorate degree | int
-------------------------------------------------------------------------------------------------------------------
After identifying relevant variables, we then need to identify the geographies of interest. We are interested in block groups in Cook County, Illinois, so first we look for the geographic identifier (FIPS code) for Illinois, then the identifiers for all counties with Illinois to find Cook County:
In [6]:
censusdata.geographies(censusdata.censusgeo([('state', '*')]), 'acs5', 2015)
Out[6]:
{'Alabama': censusgeo((('state', '01'),)),
'Alaska': censusgeo((('state', '02'),)),
'Arizona': censusgeo((('state', '04'),)),
'Arkansas': censusgeo((('state', '05'),)),
'California': censusgeo((('state', '06'),)),
'Colorado': censusgeo((('state', '08'),)),
'Connecticut': censusgeo((('state', '09'),)),
'Delaware': censusgeo((('state', '10'),)),
'District of Columbia': censusgeo((('state', '11'),)),
'Florida': censusgeo((('state', '12'),)),
'Georgia': censusgeo((('state', '13'),)),
'Hawaii': censusgeo((('state', '15'),)),
'Idaho': censusgeo((('state', '16'),)),
'Illinois': censusgeo((('state', '17'),)),
'Indiana': censusgeo((('state', '18'),)),
'Iowa': censusgeo((('state', '19'),)),
'Kansas': censusgeo((('state', '20'),)),
'Kentucky': censusgeo((('state', '21'),)),
'Louisiana': censusgeo((('state', '22'),)),
'Maine': censusgeo((('state', '23'),)),
'Maryland': censusgeo((('state', '24'),)),
'Massachusetts': censusgeo((('state', '25'),)),
'Michigan': censusgeo((('state', '26'),)),
'Minnesota': censusgeo((('state', '27'),)),
'Mississippi': censusgeo((('state', '28'),)),
'Missouri': censusgeo((('state', '29'),)),
'Montana': censusgeo((('state', '30'),)),
'Nebraska': censusgeo((('state', '31'),)),
'Nevada': censusgeo((('state', '32'),)),
'New Hampshire': censusgeo((('state', '33'),)),
'New Jersey': censusgeo((('state', '34'),)),
'New Mexico': censusgeo((('state', '35'),)),
'New York': censusgeo((('state', '36'),)),
'North Carolina': censusgeo((('state', '37'),)),
'North Dakota': censusgeo((('state', '38'),)),
'Ohio': censusgeo((('state', '39'),)),
'Oklahoma': censusgeo((('state', '40'),)),
'Oregon': censusgeo((('state', '41'),)),
'Pennsylvania': censusgeo((('state', '42'),)),
'Rhode Island': censusgeo((('state', '44'),)),
'South Carolina': censusgeo((('state', '45'),)),
'South Dakota': censusgeo((('state', '46'),)),
'Tennessee': censusgeo((('state', '47'),)),
'Texas': censusgeo((('state', '48'),)),
'Utah': censusgeo((('state', '49'),)),
'Vermont': censusgeo((('state', '50'),)),
'Virginia': censusgeo((('state', '51'),)),
'Washington': censusgeo((('state', '53'),)),
'West Virginia': censusgeo((('state', '54'),)),
'Wisconsin': censusgeo((('state', '55'),)),
'Wyoming': censusgeo((('state', '56'),)),
'Puerto Rico': censusgeo((('state', '72'),))}
In [7]:
censusdata.geographies(censusdata.censusgeo([('state', '17'), ('county', '*')]), 'acs5', 2015)
Out[7]:
{'Adams County, Illinois': censusgeo((('state', '17'), ('county', '001'))),
'Alexander County, Illinois': censusgeo((('state', '17'), ('county', '003'))),
'Bond County, Illinois': censusgeo((('state', '17'), ('county', '005'))),
'Boone County, Illinois': censusgeo((('state', '17'), ('county', '007'))),
'Brown County, Illinois': censusgeo((('state', '17'), ('county', '009'))),
'Bureau County, Illinois': censusgeo((('state', '17'), ('county', '011'))),
'Calhoun County, Illinois': censusgeo((('state', '17'), ('county', '013'))),
'Carroll County, Illinois': censusgeo((('state', '17'), ('county', '015'))),
'Cass County, Illinois': censusgeo((('state', '17'), ('county', '017'))),
'Champaign County, Illinois': censusgeo((('state', '17'), ('county', '019'))),
'Christian County, Illinois': censusgeo((('state', '17'), ('county', '021'))),
'Clark County, Illinois': censusgeo((('state', '17'), ('county', '023'))),
'Clay County, Illinois': censusgeo((('state', '17'), ('county', '025'))),
'Clinton County, Illinois': censusgeo((('state', '17'), ('county', '027'))),
'Coles County, Illinois': censusgeo((('state', '17'), ('county', '029'))),
'Cook County, Illinois': censusgeo((('state', '17'), ('county', '031'))),
'Crawford County, Illinois': censusgeo((('state', '17'), ('county', '033'))),
'Cumberland County, Illinois': censusgeo((('state', '17'), ('county', '035'))),
'DeKalb County, Illinois': censusgeo((('state', '17'), ('county', '037'))),
'De Witt County, Illinois': censusgeo((('state', '17'), ('county', '039'))),
'Douglas County, Illinois': censusgeo((('state', '17'), ('county', '041'))),
'DuPage County, Illinois': censusgeo((('state', '17'), ('county', '043'))),
'Edgar County, Illinois': censusgeo((('state', '17'), ('county', '045'))),
'Edwards County, Illinois': censusgeo((('state', '17'), ('county', '047'))),
'Effingham County, Illinois': censusgeo((('state', '17'), ('county', '049'))),
'Fayette County, Illinois': censusgeo((('state', '17'), ('county', '051'))),
'Ford County, Illinois': censusgeo((('state', '17'), ('county', '053'))),
'Franklin County, Illinois': censusgeo((('state', '17'), ('county', '055'))),
'Fulton County, Illinois': censusgeo((('state', '17'), ('county', '057'))),
'Gallatin County, Illinois': censusgeo((('state', '17'), ('county', '059'))),
'Greene County, Illinois': censusgeo((('state', '17'), ('county', '061'))),
'Grundy County, Illinois': censusgeo((('state', '17'), ('county', '063'))),
'Hamilton County, Illinois': censusgeo((('state', '17'), ('county', '065'))),
'Hancock County, Illinois': censusgeo((('state', '17'), ('county', '067'))),
'Hardin County, Illinois': censusgeo((('state', '17'), ('county', '069'))),
'Henderson County, Illinois': censusgeo((('state', '17'), ('county', '071'))),
'Henry County, Illinois': censusgeo((('state', '17'), ('county', '073'))),
'Iroquois County, Illinois': censusgeo((('state', '17'), ('county', '075'))),
'Jackson County, Illinois': censusgeo((('state', '17'), ('county', '077'))),
'Jasper County, Illinois': censusgeo((('state', '17'), ('county', '079'))),
'Jefferson County, Illinois': censusgeo((('state', '17'), ('county', '081'))),
'Jersey County, Illinois': censusgeo((('state', '17'), ('county', '083'))),
'Jo Daviess County, Illinois': censusgeo((('state', '17'), ('county', '085'))),
'Johnson County, Illinois': censusgeo((('state', '17'), ('county', '087'))),
'Kane County, Illinois': censusgeo((('state', '17'), ('county', '089'))),
'Kankakee County, Illinois': censusgeo((('state', '17'), ('county', '091'))),
'Kendall County, Illinois': censusgeo((('state', '17'), ('county', '093'))),
'Knox County, Illinois': censusgeo((('state', '17'), ('county', '095'))),
'Lake County, Illinois': censusgeo((('state', '17'), ('county', '097'))),
'LaSalle County, Illinois': censusgeo((('state', '17'), ('county', '099'))),
'Lawrence County, Illinois': censusgeo((('state', '17'), ('county', '101'))),
'Lee County, Illinois': censusgeo((('state', '17'), ('county', '103'))),
'Livingston County, Illinois': censusgeo((('state', '17'), ('county', '105'))),
'Logan County, Illinois': censusgeo((('state', '17'), ('county', '107'))),
'McDonough County, Illinois': censusgeo((('state', '17'), ('county', '109'))),
'McHenry County, Illinois': censusgeo((('state', '17'), ('county', '111'))),
'McLean County, Illinois': censusgeo((('state', '17'), ('county', '113'))),
'Macon County, Illinois': censusgeo((('state', '17'), ('county', '115'))),
'Macoupin County, Illinois': censusgeo((('state', '17'), ('county', '117'))),
'Madison County, Illinois': censusgeo((('state', '17'), ('county', '119'))),
'Marion County, Illinois': censusgeo((('state', '17'), ('county', '121'))),
'Marshall County, Illinois': censusgeo((('state', '17'), ('county', '123'))),
'Mason County, Illinois': censusgeo((('state', '17'), ('county', '125'))),
'Massac County, Illinois': censusgeo((('state', '17'), ('county', '127'))),
'Menard County, Illinois': censusgeo((('state', '17'), ('county', '129'))),
'Mercer County, Illinois': censusgeo((('state', '17'), ('county', '131'))),
'Monroe County, Illinois': censusgeo((('state', '17'), ('county', '133'))),
'Montgomery County, Illinois': censusgeo((('state', '17'), ('county', '135'))),
'Morgan County, Illinois': censusgeo((('state', '17'), ('county', '137'))),
'Moultrie County, Illinois': censusgeo((('state', '17'), ('county', '139'))),
'Ogle County, Illinois': censusgeo((('state', '17'), ('county', '141'))),
'Peoria County, Illinois': censusgeo((('state', '17'), ('county', '143'))),
'Perry County, Illinois': censusgeo((('state', '17'), ('county', '145'))),
'Piatt County, Illinois': censusgeo((('state', '17'), ('county', '147'))),
'Pike County, Illinois': censusgeo((('state', '17'), ('county', '149'))),
'Pope County, Illinois': censusgeo((('state', '17'), ('county', '151'))),
'Pulaski County, Illinois': censusgeo((('state', '17'), ('county', '153'))),
'Putnam County, Illinois': censusgeo((('state', '17'), ('county', '155'))),
'Randolph County, Illinois': censusgeo((('state', '17'), ('county', '157'))),
'Richland County, Illinois': censusgeo((('state', '17'), ('county', '159'))),
'Rock Island County, Illinois': censusgeo((('state', '17'), ('county', '161'))),
'St. Clair County, Illinois': censusgeo((('state', '17'), ('county', '163'))),
'Saline County, Illinois': censusgeo((('state', '17'), ('county', '165'))),
'Sangamon County, Illinois': censusgeo((('state', '17'), ('county', '167'))),
'Schuyler County, Illinois': censusgeo((('state', '17'), ('county', '169'))),
'Scott County, Illinois': censusgeo((('state', '17'), ('county', '171'))),
'Shelby County, Illinois': censusgeo((('state', '17'), ('county', '173'))),
'Stark County, Illinois': censusgeo((('state', '17'), ('county', '175'))),
'Stephenson County, Illinois': censusgeo((('state', '17'), ('county', '177'))),
'Tazewell County, Illinois': censusgeo((('state', '17'), ('county', '179'))),
'Union County, Illinois': censusgeo((('state', '17'), ('county', '181'))),
'Vermilion County, Illinois': censusgeo((('state', '17'), ('county', '183'))),
'Wabash County, Illinois': censusgeo((('state', '17'), ('county', '185'))),
'Warren County, Illinois': censusgeo((('state', '17'), ('county', '187'))),
'Washington County, Illinois': censusgeo((('state', '17'), ('county', '189'))),
'Wayne County, Illinois': censusgeo((('state', '17'), ('county', '191'))),
'White County, Illinois': censusgeo((('state', '17'), ('county', '193'))),
'Whiteside County, Illinois': censusgeo((('state', '17'), ('county', '195'))),
'Will County, Illinois': censusgeo((('state', '17'), ('county', '197'))),
'Williamson County, Illinois': censusgeo((('state', '17'), ('county', '199'))),
'Winnebago County, Illinois': censusgeo((('state', '17'), ('county', '201'))),
'Woodford County, Illinois': censusgeo((('state', '17'), ('county', '203')))}
Now that we have identified the variables and geographies of interest, we can download the data using censusdata.download and compute variables for the percent unemployed and the percent with no high school degree:
In [8]:
cookbg = censusdata.download('acs5', 2015,
censusdata.censusgeo([('state', '17'), ('county', '031'), ('block group', '*')]),
['B23025_003E', 'B23025_005E', 'B15003_001E', 'B15003_002E', 'B15003_003E',
'B15003_004E', 'B15003_005E', 'B15003_006E', 'B15003_007E', 'B15003_008E',
'B15003_009E', 'B15003_010E', 'B15003_011E', 'B15003_012E', 'B15003_013E',
'B15003_014E', 'B15003_015E', 'B15003_016E'])
cookbg['percent_unemployed'] = cookbg.B23025_005E / cookbg.B23025_003E * 100
cookbg['percent_nohs'] = (cookbg.B15003_002E + cookbg.B15003_003E + cookbg.B15003_004E
+ cookbg.B15003_005E + cookbg.B15003_006E + cookbg.B15003_007E + cookbg.B15003_008E
+ cookbg.B15003_009E + cookbg.B15003_010E + cookbg.B15003_011E + cookbg.B15003_012E
+ cookbg.B15003_013E + cookbg.B15003_014E +
cookbg.B15003_015E + cookbg.B15003_016E) / cookbg.B15003_001E * 100
cookbg = cookbg[['percent_unemployed', 'percent_nohs']]
cookbg.describe()
Out[8]:
percent_unemployed
percent_nohs
count
3983.00
3984.00
mean
12.00
15.19
std
10.09
13.23
min
0.00
0.00
25%
4.86
4.75
50%
9.24
11.66
75%
16.28
22.46
max
91.86
77.43
Next, we show the 30 block groups in Cook County with the highest rate of unemployment, and the percent with no high school degree in those block groups.
In [9]:
cookbg.sort_values('percent_unemployed', ascending=False).head(30)
Out[9]:
percent_unemployed
percent_nohs
Block Group 1, Census Tract 8357, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:835700> block group:1
91.86
0.00
Block Group 2, Census Tract 6805, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:680500> block group:2
66.27
19.54
Block Group 3, Census Tract 5103, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:510300> block group:3
64.07
16.97
Block Group 2, Census Tract 6809, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:680900> block group:2
61.46
42.33
Block Group 1, Census Tract 4913, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:491300> block group:1
56.40
14.64
Block Group 5, Census Tract 2315, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:231500> block group:5
55.58
44.72
Block Group 3, Census Tract 8346, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:834600> block group:3
54.96
17.85
Block Group 2, Census Tract 6706, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:670600> block group:2
54.13
9.57
Block Group 2, Census Tract 8386, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:838600> block group:2
53.78
48.41
Block Group 5, Census Tract 4910, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:491000> block group:5
53.57
38.23
Block Group 1, Census Tract 5401.02, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:540102> block group:1
52.90
6.67
Block Group 2, Census Tract 6712, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:671200> block group:2
52.84
26.98
Block Group 1, Census Tract 7109, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:710900> block group:1
52.68
19.08
Block Group 1, Census Tract 3406, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:340600> block group:1
51.76
42.59
Block Group 1, Census Tract 6712, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:671200> block group:1
51.53
37.70
Block Group 2, Census Tract 4910, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:491000> block group:2
51.47
26.50
Block Group 3, Census Tract 4303, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:430300> block group:3
51.41
14.85
Block Group 1, Census Tract 6810, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:681000> block group:1
51.10
24.38
Block Group 5, Census Tract 6811, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:681100> block group:5
50.00
31.95
Block Group 6, Census Tract 7104, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:710400> block group:6
50.00
9.34
Block Group 2, Census Tract 6812, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:681200> block group:2
49.82
20.29
Block Group 1, Census Tract 8290, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:829000> block group:1
49.57
28.97
Block Group 3, Census Tract 6813, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:681300> block group:3
49.51
22.92
Block Group 1, Census Tract 6811, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:681100> block group:1
49.32
33.73
Block Group 2, Census Tract 7107, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:710700> block group:2
49.00
17.18
Block Group 6, Census Tract 4804, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:480400> block group:6
48.68
8.32
Block Group 1, Census Tract 4207, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:420700> block group:1
48.63
14.08
Block Group 1, Census Tract 6715, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:671500> block group:1
48.28
30.24
Block Group 4, Census Tract 4603.02, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:460302> block group:4
48.00
48.27
Block Group 3, Census Tract 8424, Cook County, Illinois: Summary level: 150, state:17> county:031> tract:842400> block group:3
47.80
0.00
Finally, we show the correlation between these two variables across all Cook County block groups:
In [10]:
cookbg.corr()
Out[10]:
percent_unemployed
percent_nohs
percent_unemployed
1.00
0.29
percent_nohs
0.29
1.00
Content source: jtleider/censusdata
Similar notebooks: