Hospital capacity per capita


Given the following two datasets, one showing hospital capacity and the second showing state population, show the top ten states that have the most hospital beds per capita. You'll want to use the 'state' and 'total_beds_7_day_avg' fields to calculate the capacity by state. You'll also want to filter the hospital capacity dataset on collection_week = '2020-12-11' (the dataset is formatted to have a weekly snapshot of current hospital bed utilization) and total_beds_7_day_avg >= 0.

To help get you started, below is code (Python) to import the referenced dataset:

# Import libraries
%matplotlib inline
import pandas as pd
import matplotlib.pyplot as plt
import numpy as np
import seaborn as sns
# Import data
hospital_cap = pd.read_csv('')
state_pop = pd.read_csv('')


Access restricted

Subscribe to premium account to see the solution.

Get premium now