Air Quality of the US

Data Wrangling

Data set is organized by combining 7 different data sets obtained from United States Environment Protection Agency. Data Wrangling is done through splitting columns and rows, filtering the data set, aggregating and by performing basic statistic operations.

Data Visualization

Above graph represents the percentage of unhealthy days of each state over the past 7 years.
The following insights can be drawn from the above graph:

• Hawaii is the state with most unhealthy air quality in the past 7 years.
• Besides being the most unhealthy state, Hawaii almost has negligible unhealthy days in the year 2019 & 2020
• Vermont, Maine & Nebraska are the states with best air quality over the past 7 years.
  
  
  
  
  

The above heat map shows the percentage of good days by state over the past 7 years.This visualization is helpful to quickly look at the distribution of percentage of good days over the years of each state.

The above maps show the percentage of unhealthy days over the past 7 years. Hovering over the states gives extra information regarding percentage of good days,moderate days and unhealthy for sensitive groups.

Insights from above visualizations

• From the above graphs we can conclude that Alaska and California are among the top 3 bad quality states continously for the past 7 years. This information can be used to take measures in the following states to regulate the air quality.
• Unhealthy days percentage has been gradually decreasing from 2018 with a drop of 6 % and in 2019 a drop of 4.5 % was observed.
• Unhealthy days percentage of Puerto Rico has suddenly raised from 2019 to 2020.
  
  
  
  
  

This visualization shows how the Unhealthy days and Unhealthy days for sensitive groups are distributed over the years.

These visualizations show the top cities with unhealthy days for sensitive groups,unhealth days,and very unhealthy days of 2020. This data can be used to take appropriate measures to regulate the air quality in the respective cities.