shuchita-rahman / covid-19-data-exploration-using-sql

COVID-19-Data-Exploration-Using-SQL

Resources

Python Version: 3.7
Installation : pip install -U pandasql Packages: pandas, pandasql, display
Dataset : https://ourworldindata.org/covid-deaths

Operation

• SELECT
• WHERE
• FROM
• UNION
• Aggregate Functions : ORDER BY, MAX, SUM

Overview

• Collected data from 2020-02-01 to 2021-07-08 consist of 102458 rows.
• Tried to find out the effect of the pandemic in different countries and where Bangladesh stands.
• Find out likely hood of getting infected in Bangladesh.
• Find out the death count in Asia and how Bangladesh doing.
• Find out if the vaccine is decreasing death worldwide.