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('https://raw.githubusercontent.com/erood/interviewqs.com_code_snippets/master/Datasets/reported_hospital_capacity.csv') state_pop = pd.read_csv('https://raw.githubusercontent.com/erood/interviewqs.com_code_snippets/master/Datasets/state_pop_abbrev.csv')
Subscribe to premium account to see the solution.Get premium now