Air Quality Index in CA Dashboard

Title: Deeper Dive into Air Quality Index in California
Subtitle: A dashboard for public health professionals
Data source: ca_aqi
Background: The data shows air quality levels across years from 1980 to 2022 in California cities. The research question that I was interested in looking at is what a “good” AQI distribution really looks like when we dive deeper into the data. Public health professionals would be interested in this dashboard as a starting point for one of the top 5 cities in California, or in utilizing the second graph, looking at specific years and the environmental impacts.
Results: The first graph utilized data with the top 5 highest mean aqi levels across the general dataset and looked at the distribution of category markers “good”, “moderate”, “unhealthy for sensitive groups”, “unhealthy”, “very unhealthy”, and “hazardous”. As expected, the bars for very unhealthy and hazardous are very low for all of the top five cities, but the overall distribution is not as similar as may be expected. For the second graph, I expanded my data to include the top 7 cities, and looked at the distribution by quartiles rather than categories. Quartiles allowed me to create ribbons on a line graph that could show overlap across different cities.