Air Quality Data Analysis: AQI, PM2.5 Averages & Exceedances

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Convert gas readings from ppb to µg/m³ at 25 °C and at the European 20 °C reference, and turn WHO guideline values back into ppb.
• Turn four days of hourly PM2.5 readings with gaps into daily statistics: valid hours, data completeness, the 24-hour mean and a Valid/Incomplete flag.
• Convert ten daily PM2.5 means into US AQI values: truncate the concentration, find its breakpoint row with MATCH, read the category and interpolate the index linearly.
• Combine four pollutant sub-indices into the daily AQI of a summer week at Harbor Road, name the main pollutant, look up the category and highlight the unhealthy days.
• Compare a year of daily PM2.5 means at both Riverton stations with the WHO 2021 24-hour guideline: exceedance days per station, joint exceedances, exceedances in Q1 and the 99th percentile.
• Extract the hour from two weeks of hourly roadside NO2 readings, average every hour of the day, find the peak hour and chart the daily cycle.
• Label eight weeks of daily roadside NO2 means as weekday or weekend, compare the two means, express the weekend reduction in percent and count the exceedance days of each day type.
• Build Riverton's annual NOx and PM2.5 inventory from activity data and emission factors, find the share of wood heating in PM2.5 and test a stove-replacement scenario.