This Markdown document is part of a bigger document that aims to answer business questions about the data provided by the municipality of Eindhoven. Each team member was responsible for 2 questions. I was responsible for understanding if the noise levels captured by the devices were correlated to their location. Besides that, I was also responsible for identifying possible trends related to the NO2 levels in the dataset.
Is there a correlation between noise levels and proximity to major roadways or industrial zones?
In the map below you can find the spots where the devices are located and the noise (in decibels) captured in each point. Even though the devices are all in the same area, it is possible to say that the noise levels around the Onze lieve Vrouwestraat are slightly higher than the other values.
Are there noticeable trends in air quality, noise, and traffic speed over days in which the data was recorded? If so, what might be driving these trends?
It is possible to notice that the first columns of the dataset regarding the values of NO2 are zero. That is probably because the Netherlands was in a period of lockdown. However, in the second half of November 2021, the government proposed implementing the “2G rule”, a measure that allowed individuals who are vaccinated or have recovered from a COVID-19 infection from being able to enter hotels, restaurants, cafes, cultural and artistic places, events, use non-essential services and go a few days to the office (Wikipedia). Besides that, the most common office days when people were allowed to work a few days a week in the office were Wednesday, Tuesday, and Thursday. That is probably why there is a spike in NO2 emissions on those days.
## NO2 datetime_short
## 1 0 2021-11-02:10:50:01
## 2 0 2021-11-02:10:50:01
## 3 0 2021-11-02:11:10:00
## 4 0 2021-11-02:11:20:00
## 5 0 2021-11-02:11:50:00
## 6 0 2021-11-02:12:10:00## NO2 datetime_short
## 3538 18 2021-11-30:15:10:00
## 3539 32 2021-11-30:16:40:00
## 3540 19 2021-11-30:17:00:00
## 3541 19 2021-11-30:17:00:00
## 3542 16 2021-11-30:20:40:00
## 3543 12 2021-11-30:21:10:00