Exploratory Data Analysis

1) Compiled files for all the three years into one file and removed null values

2) Used the group by function on weekending and provider state followed by the count operation to get specifics about shortage in supplies and staff at state level.

3) Calculated percentages for shortage in Health Professionals by considering (Yes values / Sum of total values)

4) Calculated percentages for available stock in supplies by considering (No values / Sum of total values)

5) Visualized the data using maps and line charts.