yasinemegherbi21-byte/morocco-afcon-worldcup-economic-pipeline

End-to-end data engineering pipeline analyzing Morocco's economic, tourism, infrastructure, and host-city preparation for AFCON 2025 and FIFA World Cup 2030. # Morocco AFCON 2025 & FIFA World Cup 2030 Economic Impact Pipeline ## Project Overview This project analyzes Morocco's economic growth, tourism development, infrastructure investments, and host-city preparations leading up to AFCON 2025 and the FIFA World Cup 2030. The objective is to understand how Morocco is preparing for these major international sporting events through economic development, transportation improvements, stadium construction, airport expansion, and tourism growth. The project combines Data Engineering, Data Analysis, and Machine Learning using a complete end-to-end pipeline. --- ## Project Objectives * Analyze Morocco's economic indicators over time. * Study tourism growth and tourism revenues. * Explore infrastructure investments related to AFCON 2025 and the FIFA World Cup 2030. * Analyze host cities selected for the events. * Assess Morocco's event readiness using project timelines and infrastructure status. * Demonstrate a complete Data Engineering workflow using ETL pipelines, PostgreSQL, Docker, Airflow, and Streamlit. --- ## Technologies Used * Python * Pandas * PostgreSQL * SQLAlchemy * Docker * Apache Airflow * Streamlit * Plotly * Scikit-Learn * Git & GitHub --- ## Datasets ### Economic Indicators (World Bank API) * GDP Growth (%) * GDP Per Capita (Current US$) * Inflation (%) * Unemployment (%) * Foreign Direct Investment (FDI) ### Tourism Indicators (World Bank API) * International Tourism Arrivals * International Tourism Receipts ### Infrastructure Projects Infrastructure projects related to AFCON 2025 and FIFA World Cup 2030: * Stadium Projects * Airport Expansions * Port Developments * Railway Investments * Urban Mobility Projects * Road Infrastructure ### Host Cities * Casablanca * Rabat * Tangier * Marrakech * Agadir * Fes * Benslimane --- ## ETL Pipeline The project follows a traditional ETL process: ### Extract Data is collected from World Bank APIs and curated infrastructure datasets. ### Transform …