In this work we apply a rigorous and reproducible data analytics process for validation and analysis of the historical data from Bogotá (Colombia) air quality monitoring network since 1998. The reasons for addressing this research study stem from the lack of a consistent approach for cleaning, validating and reporting air quality data. By analyzing the whole dataset, we are aiming at providing citizens and the city authorities with a clear view of the current situation of air quality and of its historical evolution. Without any loss of generality, we focus our analysis on both respirable and fine particulate matter (PM10 and PM2.5) concentrations, which in Bogotá and worldwide are source of concern for their negative impacts on human health. We develop a reproducible and flexible data cleaning methodology for particulate matter concentration data reported by the local authorities, which allows customizing and applying configurable validation rules. Then, we present statistical descriptive analyses by providing intuitive data visualizations, characterizing historical and spatial change of air pollutant levels. Results raise concerns for the high percentage of invalid data, as well as the high levels of PM2.5 and PM10 ambient concentrations as observed in the valid portion of the available data, which frequently exceed national and international air quality standards. The data exhibit encouraging signs of air quality improvement, particularly for PM10. However, the analyses indicate that significant differences exist across Bogotá, and particularly in the south-west zone of the city annual concentrations of particulate matter are up to three or four times the WHO recommendations. We are confident on the methodology and results from our analysis are useful both for local environmental authority and the general public to help in obtaining consistent conclusions from the available data.

中文翻译：

---

波哥大十年空气质量：描述性分析

在这项工作中，我们应用严格且可重复的数据分析过程来验证和分析自 1998 年以来波哥大（哥伦比亚）空气质量监测网络的历史数据。 解决这项研究的原因源于缺乏一致的清洁方法，验证和报告空气质量数据。通过分析整个数据集，我们旨在让市民和市政当局清楚地了解空气质量的现状及其历史演变。在不失一般性的情况下，我们将分析重点放在可吸入颗粒物和细颗粒物（PM10 和 PM2.5）浓度上，这在波哥大和世界范围内都是令人担忧的问题，因为它们对人类健康有负面影响。我们为地方当局报告的颗粒物浓度数据开发了一种可重复且灵活的数据清理方法，允许自定义和应用可配置的验证规则。然后，我们通过提供直观的数据可视化，表征空气污染物水平的历史和空间变化来进行统计描述性分析。结果引起了人们对高比例无效数据的担忧，以及在可用数据的有效部分中观察到的高水平 PM2.5 和 PM10 环境浓度，这些数据经常超过国家和国际空气质量标准。数据显示出空气质量改善的令人鼓舞的迹象，尤其是 PM10。然而，分析表明波哥大各地存在显着差异，尤其是西南地区的城市颗粒物年浓度高达世卫组织建议的三四倍。我们对方法论充满信心，我们的分析结果对当地环境当局和公众都有帮助，有助于从可用数据中获得一致的结论。