Automated Daily Maximum Transformation Pipeline for the NOAA LCD

Developed a robust ETL pipeline for converting long-term hourly weather data NOAA’s LCD into daily maximum/average quantities useful for public health inquries. The program imports hourly readings of weather, makes corrections, and outputs daily maximum/average readings for heat related quantities. It also creates probability distribution plots for those values for each city, and consolidates statistical information for each one of those cities into one large database, allowing for easy comparisons of extreme heat behavior for cities across the United States or even the world.