Covid-19 India Analysis
Sachin Yadav
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
0
Views
2
Diwali Sales Analysis
Loan Approval Prediction System
