COVID-19 Global Data Tracker Report

Project Title: COVID-19 Global Data Tracker

1. Introduction

The COVID-19 pandemic has significantly impacted global health, economies, and daily life. To better understand the progression of the virus, this project analyzes COVID-19 cases, deaths, recoveries, and vaccinations worldwide using real-world data from Our World in Data. The goal is to identify trends, compare metrics across countries, and derive key insights through exploratory data analysis (EDA) and visualizations.

---

2. Data Collection & Preparation

Data Source:

✅ Dataset: Our World in Data COVID-19 Dataset
✅ Format: CSV file
✅ Key Fields Used:

• date: Timestamp of data entry
• location: Country or region name
• total_cases: Cumulative confirmed cases
• total_deaths: Total reported deaths
• new_cases: Daily new infections
• new_deaths: Daily new fatalities
• total_vaccinations: Number of vaccine doses administered

Data Cleaning:

• Converted date to datetime format ✅
• Handled missing values using forward fill ✅
• Filtered relevant countries for analysis ✅

---

3. Exploratory Data Analysis (EDA) & Visualizations

Trend Analysis: Cases & Deaths Over Time

• A line chart visualizes the total cases over time for selected countries (e.g., USA, India, South Africa, Brazil).
• The progression shows spikes during pandemic waves, lockdown phases, and vaccination drives.

Comparison of COVID-19 Impact Across Countries

• A bar chart presents the top countries by confirmed cases.
• A death rate calculation (total_deaths / total_cases) highlights the severity in different regions.

Vaccination Progress & Coverage

• A cumulative line chart shows vaccine rollout trends over time.
• Some nations reached high vaccination coverage, while others lagged due to logistical challenges.

Choropleth Map: Global COVID-19 Cases

• A world map visualization provides a geographical view of case density.
• Countries with the highest infection rates appear in darker shades.

---

4. Key Insights & Findings

🔹 Global Case Trends: The highest spikes occurred in late 2020 and mid-2021 during new variant outbreaks.
🔹 Death Rate Analysis: Certain regions had disproportionately high fatality rates, likely due to healthcare limitations.
🔹 Vaccination Rollout: Countries with early vaccine access experienced faster recovery trends in cases and deaths.
🔹 Anomalies Identified: Some countries reported unexpected case drops due to testing policies or data inconsistencies.

---

5. Conclusion & Recommendations

📌 Summary of Findings:

• COVID-19 spread rapidly with multiple waves affecting global populations differently.
• Vaccination efforts significantly reduced severe cases and deaths.
• Data analysis helped highlight key trends, disparities, and anomalies.