Exploratory analysis of scientific data from 01/01/2019 to 12/31/2019 obtained from the Air Quality web portal of the Madrid City Council.
The city of Madrid has suffered in recent years some peaks in the concentration of pollutants harmful to health that have forced the administration to carry out a series of measures, such as reducing speed or traffic on certain dates.
This analysis aims to study how tropospheric ozone precursors affect both, as well as some environmental factors such as radiation, temperature and relative humidity.
To carry out this study, the information provided by the Air Quality web portal of the Madrid City Council.
First, the information contained in the informative documents was collected to understand the data collected in the aforementioned databases.
The second step was to clean the tables, eliminating those measures that were not considered valid by the General Directorate of Sustainability and Environmental Control of the Madrid City Council. As well as columns that did not provide relevant information for this study, such as the code of the municipality, province and sampling point. A date column was also created to collect the dates by day in the case of annual values and by hours in the case of air quality in January 2020.
The third step consisted of filtering the data to collect the relevant data for this study, such as those related to:
- The concentration of pollutants: VOCs, NOx and O3.
- The meteorological data of temperature, relative humidity and radiation.
With all the data collected in the different stations, station number 24, corresponding to Casa de Campo, was selected for the study. Because it is one of the stations that collects the highest ozone concentration and because it also collects the measurements of the other variables that are going to be studied in this work.
Applying correlations between the different variables that are studied, the following conclusions have been reached:
- VOCs and NOx reagents influence the formation of tropospheric ozone. NOx is the limiting reagent in the case of the city of Madrid.
- The higher the temperature, the higher the formation of tropospheric ozone, an endothermic reaction.
- The greater the radiation, the greater the formation of tropospheric ozone.
- The higher the relative humidity, the lower the formation of tropospheric ozone.
- The seasons of the year with a greater formation of tropospheric ozone are spring and summer.
- The peaks with the highest concentration of Ozone are collected in the time zone between 14:00 and 16:00.
Regarding the areas with the highest concentration of tropospheric ozone, precursors are the locations near the meteorological stations of Plaza Elíptica, Escuelas Aguirre and Plaza de España.
All this work you can see my Github repository, where you can find more interactive visualizations like this one.