Healthcare Accessibility Analysis in Barcelona's Neighborhoods

Overview

This repository contains a data-driven analysis exploring the relationship between median income and the distribution of healthcare facilities across the neighborhoods of Barcelona. This project was developed as part of a data analytics initiative to understand socio-economic impacts on healthcare accessibility.

---

Authors

https://github.com/yosbenj

---

Repository Structure

1. Data Cleaning: Notebooks for data cleaning and preprocessing.
2. Descriptive Analytics: Analysis of demographic and healthcare data.
3. Hypothesis Testing: Statistical testing to explore correlations between income levels and healthcare facility distribution.
4. SQL Save and Read: Scripts for database interactions.
5. Additional Visualizations: Python scripts for generating interactive visualizations.
6. SQL Queries.sql: SQL queries used for data extraction and analysis.
7. Barcelona-Geodata (used for the maps).
8. Presentation (pdf format).
9. Raw Data and Clean Data.
10. README.md: This file, explaining the project and navigation.

---

Interactive Visualizations

Explore the interactive maps and visualizations of healthcare distribution and median income across Barcelona's neighborhoods:

1. Link to Tableau Dashboard: https://public.tableau.com/app/profile/yosra.benjelloun.el.hassani/viz/Project_17001859253750/Dashboard1

2. Link to Interactive Map 1 (median income by neighborhoods): https://datawrapper.dwcdn.net/Qfzgi/1/

3. Link to Interactive Map 2 (median income by districts): https://datawrapper.dwcdn.net/eG16l/1/

---

Final Presentation

For a detailed presentation of my findings and insights, refer to the "Presentation" folder.

Healthcare Accessibility in Barcelona's Neighborhoods: https://github.com/yosbenj/Mid_Bootcamp_Project/blob/main/Presentation/Project%20Presentation_%20Health%20Disparities.pdf

---

Data Sources

Data on healthcare facilities and demographic information was sourced from Official Barcelona Open Data: https://opendata-ajuntament.barcelona.cat/en/

Additional context and data were obtained from:

1. Demographic indicators. Population density (inhabitants / ha) of the city of Barcelona: https://opendata-ajuntament.barcelona.cat/data/en/dataset/est-densitat/resource/540e48d8-c432-43df-b3ba-a0cf009b90ef

2. Average gross taxable income per household (€/Year) for the city of Barcelona: https://opendata-ajuntament.barcelona.cat/data/en/dataset/atles-renda-bruta-per-llar

3. Hospitals and primary health services of the city of Barcelona: https://opendata-ajuntament.barcelona.cat/data/en/dataset/sanitat-hospitals-atencio-primaria