Covid-19 India Analysis by Sachin YadavCovid-19 India Analysis by Sachin Yadav

Covid-19 India Analysis

Sachin Yadav

Data Scraper

Data Visualizer

Data Analyst

Microsoft Excel

Python

SQL

Introduction

The COVID-19 pandemic has had a profound impact on public health, and understanding the data is crucial for decision-making and resource allocation. This project, assigned by our training institution "Masai" with a tight 7-day deadline, aims to provide valuable insights and create a data-driven dashboard to aid in understanding the pandemic's progression and its effects on different regions of India.

Problem Statement

Extract COVID-19 data for India using Python and the requests module.

Parse and clean the data, ensuring consistency and handling missing values.

Perform SQL aggregations to create an Excel dashboard with the following insights:

Tech Stack

Python: Data extraction and EDA

MySQL: Aggregation for table creation

Excel: Dashboard creation and data presentation

Power Query: Minor data adjustments

API: Used API As a Data Source

Jupyter Notebook: Used Jupyter as IDE

Like this project

Posted Dec 26, 2023

The COVID-19 History of India Discover our in-depth examination of the pandemic's geographic effects, which offers historical context for future readiness.

Likes

Views