Python US Census API Tutorial (Part III) - Plot State Male-to-Female Population Ratios

Link to census data tables:
https://api.census.gov/data/2015/acs/acs5/spt/variables.html

Tutorial code:
1 import plotly.offline as plt
2 from us.states import lookup
3 from census import Census
4 import pandas as pd
5 from os import getenv
6
7 # Grab census data
8 c = Census(getenv("CENSUS_API_KEY"))
9 male_data = c.acs5.state("B01001_002E", Census.ALL)
10 female_data = c.acs5.state("B01001_026E", Census.ALL)
11
12 # Format male and female data
13 def format_data(data, key, new_key):
14 formatted_data = [{"state": lookup(entry["state"]).abbr, \
15 new_key: entry.pop(key)} for entry in data]
16 return pd.DataFrame(formatted_data)
17
18 male_census_dataframe = format_data(male_data, "B01001_002E", "Male_POP")
19 female_census_dataframe = format_data(female_data, "B01001_026E", "Female_POP")
20
21 # Merge male and female dataframes
22 population_ratio_dataframe = pd.merge(male_census_dataframe, \
23 female_census_dataframe, on="state")
24
25 # Calculate the male-to-female population ratio
26 population_ratio_dataframe["Male_to_Female_Ratio"] = \
27 population_ratio_dataframe["Male_POP"] / \
28 population_ratio_dataframe["Female_POP"]
29
30 # Build plot data
31 data = [
32 dict(
33 type="choropleth",
34 locations=population_ratio_dataframe["state"],
35 z=population_ratio_dataframe["Male_to_Female_Ratio"].astype(float),
36 locationmode="USA-states",
37 )
38 ]
39
40 # Save the plot to an HTML file
41 fig = dict(data=data, layout={"geo": {"scope": "usa"}})
42 plt.plot(fig)

Soundtrack:

"A Vibe Nostalgic" by Mindseye
https://freemusicarchive.org/music/Mi...
Beyond cropping a snippet from the full song, no changes were made to this content.

Male-Female Office Video Clip:
https://pixabay.com/videos/office-corporate-business-95122/