This project investigates the relationship between air pollution, temperature change, and mortality rates across countries with high and low pollution levels.
The study compares Niger, Mauritania, and Qatar (high pollution) with Tuvalu, Nauru, and American Samoa (low pollution).
- Analyze how air pollution correlates with death rates.
- Explore temperature change impacts on public health.
- Compare high vs. low pollution countries.
- Visualize long-term pollution and mortality trends.
- Python (Pandas, NumPy, Matplotlib, Seaborn)
- SQL (data extraction and querying)
- Jupyter Notebook
- SQLite for data storage
- Excel for initial data review
- Line charts showing pollution and mortality trends (1990–2020)
- Parallel coordinate plots showing correlations
- Comparative country analysis of deaths vs. pollution
- Time-series temperature visualizations
| Dataset | Description | Source |
|---|---|---|
air_pollution.csv |
Annual air pollution index by country | WHO / World Bank |
temperature_change.csv |
Yearly temperature deviation data | Climate Data Portal |
death_rates.csv |
Deaths due to ambient, household, and risk air pollution | IHME Global Health Data |
The SQL script (sql/project.sql) contains queries for:
- Country-level aggregation
- Combined death metric creation
- Filtering by high- and low-pollution countries
| Metric | High-Pollution Countries | Low-Pollution Countries |
|---|---|---|
| Pollution Levels | High & fluctuating | Stable & low |
| Temperature Change | Rising steadily | Mild increase |
| Mortality | Upward trend | Consistently low |
- Pollution correlates strongly with mortality and temperature rise.
- High-pollution nations face worsening environmental and health outcomes.
- Low-pollution nations benefit from sustainable ecosystems and lower death rates.
Siddhant Bahadkar
MSc Data Analytics, National College of Ireland
LinkedIn | GitHub
- Code & Data: MIT License
- Report (PDF): CC BY-NC-SA 4.0