COVID-19_Analysis on World and US State Data
This project deals with 4 diffrent aspects on COVID-19 Analysis
-
Web Scraping: Webscrapping was performed on the website https://www.worldometers.info/coronavirus/ Data for all the World Countries was extracted and cleaned Data for all the USA states was extracted and cleaned Data Visualizations were performed on the dataset.
-
Using officially released data to perform analysis over course of the inception of the pandemic The data was collected and analysed using multiple visualization packages in python Dynamic dashboards were created and hosted on site in the process using the dstack.ai The link to the dashboards 'https://dstack.ai/jayshil97'
-
Data Collection in Relational Database (RDBMS) The data which was web scrapped was collected and stored in relational database (SQL Server) A task sheduler was created to run the script daily to collect data
-
Tableau Analysis: I have created tableau Analysis using the dataset link to the Tableau Public is:
https://public.tableau.com/profile/jayshil.jain#!/vizhome/COVIDDashboard_15922437933840/COVIDDashboard https://public.tableau.com/profile/jayshil.jain#!/vizhome/COVIDTimeSeries_15886643195770/COVID-19Analysis
- Images - Stores the images generated in the project
- Analysis_for_COVID_19.html - HTML page to show all the dynamic visualizations generated by plotly
- Analysis_for_COVID_19.ipnb - The code for all the visualizations and dstack integration (Worldwide)
- COVID-19 World Data Web Scrapping.ipynb - The code for all the Web Scrapping and RDBMS integration of all the world countries
- COVID19_USASTATES_WebScraping.ipynb - The code for all Web Scrapping and RDBMS integration of all the US States
https://www.worldometers.info/coronavirus/
https://raw.githubusercontent.com/CSSEGISandData/
A special thanks to prof Nicholas Brown for his expert assistance and guidence.