In this project I created a web application with an interactive dashboard to explore public air quality data from the city of Madrid, where I am originally from.

I compiled the data from the city hall's repository, which offers separated files for each year. I combined all the datasets, cleaned and reformatted the data and hosted it in a AWS SQL database.

I used streamlit to build an application which connects to the database and presents the data through an interactive dashboard. I deployed the app on Streamlit's Community Cloud to make it accesible.

You can try the application following the link below.

And check out the repository on Github