Appendix H — Practice Problem Solutions — Chapter 7

H.1 Solution Section 7.9.1

df = pd.DataFrame(state_cancer_data)

H.2 Solution Section 7.9.2

df["Cancer Deaths Per 100k"] = df["Cancer Deaths"] / df["Population"] * 100_000

H.3 Solution Section 7.9.3

df.query("`Cancer Deaths Per 100k` >= 180 and `Median Household Income` < 68_500")

H.4 Solution Section 7.9.4

df.plot(kind="scatter", x="Median Household Income", y="Cancer Deaths Per 100k")

H.5 Solution Section 7.9.5

df.plot(kind="scatter", x="Percent Aged 65+", y="Cancer Deaths Per 100k")