COVID-19 Deaths Analysis in SQL

Project Details

This Python project involves comprehensive data analysis on COVID-19 deaths in the USA. The initial steps include data cleaning, where 'N/A' and 'Data not available' fields are replaced with NULL for accurate calculations. The project then delves into various aspects, such as identifying states with the highest positive tests and hospital admissions, investigating changes in admissions, and assessing death rates over different periods. Notably, the analysis uncovers insights into regional variations, with regions 4 and 5 facing significant challenges.

Use case:

In a real-world scenario, this project aids healthcare professionals, policymakers, and researchers by providing valuable information for resource allocation, identifying critical regions, and understanding the dynamics of COVID-19 impact. The ability to explore and visualize data trends supports informed decision-making and helps implement targeted strategies to combat the pandemic effectively.