Riad Ghoneim's Portfolio

Data Science & Visualization Portfolio - LSE Course Challenges

CC1: Hosting

Display charts in your own site.

Chart 1: Basic Visualization

Chart 2: Second Visualization

CC2: Building

Create your own visualizations.

Chart 1: Custom Built Visualization

Chart 2: Map of the London Underground System

CC3: Debate

Use visualizations in policy commentary.

Policy Topic

The UK should implement a four-day work week to improve productivity and worker wellbeing, as international evidence shows reduced hours increase output per hour.

Chart 1: Productivity vs Working Hours

Countries working fewer hours demonstrate higher productivity per hour.

Chart 2: Worker Burnout Rates

Burnout rates quadruple from part-time to overtime schedules.

CC4: Replication

Re-create, then improve, someone else's chart.

Original Chart

Source: Fox News Bush Tax Cuts (2012)

Original Fox News Chart

Improved Chart

Improvements: Fixed truncated Y-axis to start at zero, added proper context and labels, included data source, used clear colors, and showed true proportional change.

CC5: Accessing Data

API and web scraping tasks.

API Chart: Inflation Across North Africa

API Description:

Base URL: https://api.worldbank.org/v2/

Elements: country codes (mar;egy;dza), indicator (NY.GDP.DEFL.KD.ZG), format (json), per_page (300), date range (1990:2024)

Full URL: https://api.worldbank.org/v2/country/mar;egy;dza/indicator/NY.GDP.DEFL.KD.ZG?format=json&per_page=300&date=1990:2024

Scraper Chart: Egypt Economic Media Sentiment

This chart shows scraped data on Egyptian media sentiment from Arabic news sources.

Challenge: The main challenge was finding websites without CloudFlare protection.

</> View Scraper Code

CC6: Loops

Build a dashboard using batch-downloaded data.

Colab Notebook: View Python Code

Dashboard theme: Egypt Economic Indicators (2000-2024)

</> View Python Loop Code

CC7: Maps

Base maps and choropleths.

Map 1: Scotland - Major Cities

Coordinates map: Circle size represents population of major Scottish cities.

Map 2: Wales - Disposable Income

Choropleth: Color intensity shows disposable income by region.

CC8: Big Data

Extracting stories from millions of prices.

Dataset used: AutoCPI

Using daily supermarket price data, I tracked essential food prices to show UK inflation trends from 2023-2024, revealing butter experienced the highest increase at 12.3%.

Chart 1: Essential Food Price Trends

Chart 2: Price Change Comparison

CC9: Interactive & Analytics Charts

Advanced interactive and analytical visualizations.

Interactive Chart: Consumer Confidence

Features: Date range sliders for exploring temporal patterns.

Analytics Chart: Regional Inflation Comparison

Method: Multi-country time series analysis.

CC10: Advanced Analysis

An Advacned Impuplse Response Function From My Dissertation used for the Project

CC10: Machine Learning

View Colab Notebook

Higher inflation correlates with lower GDP growth in Egypt. Using regression, I test whether current inflation predicts next year's economic growth.