COVID-19 ANALYSIS
The objective of this project was to analyze the COVID-19 situation of India and its impact on different aspects of daily life like mobility in public places, power consumption, etc. It also describes the vaccination status of the nation. In this analysis, various data wrangling techniques were used to handle inconsistencies, calculate summaries and develop insights out of raw data.
Impact on Various Aspects of life
Course - CPSC 4810 | PDD Data Analytics
description
In this project, 5 datasets related to Covid cases, testing, vaccination, power consumption, and mobility were merged together after cleaning and checking the accuracies of each dataset. Exploratory Data Analysis was performed on the individual as well as merged datasets using Pandas library of Python. Visually appealing visualizations were created using matplotlib and seaborn libraries to analyze various trends and answer the following research questions:
- Which provinces had the worst change in mobility during the Covid-19 pandemic?
- Is there any relationship between Covid-19 Confirmed/Death cases and mobility in India?
- Is there any relationship between Covid-19 Confirmed/Death cases and the Power Consumption in India?
- Which parts of India were affected the most during Covid-19?
- Is the number of Covid confirmed/Death cases related to the ratio of urban to the rural population?
​
More details can be found on the Github repository where the project has been hosted.
​
Skills used
-
Performed Exploratory Data Analysis by handling inconsistencies, missing data, and inaccuracies of 5 datasets using Pandas & NumPy libraries n Python ​
​
-
Analyzed relationships between different variables relating to COVID-19 outbreak in different cities and their impact on public services such as electricity consumption, mobility in public places, etc.
​
-
Visualized the most affected cities in terms of various parameters to gather insights on worst affected regions using matplotlib & seaborn libraries of Python.
​
-
Developed and answered research questions about the COVID-19 situation by gathering insight from visualizations & statistical summaries.
​
-
Demonstrated the analysis process to class by explaining each step of analysis and answered various queries of fellow students as well as instructors.