COVID19

The program is fully automatical. main.ipynb is a script that you can run all cells at once and get every graph and xls file with latest data possible.

I made this program just for practice. It originally used python and Google Spreadsheets API. I got data from: https://gisanddata.maps.arcgis.com/apps/opsdashboard/index.html?fbclid=IwAR3S1IMXpzD-EfOPqWCDttt96vuDQ77Uddrqhhf-iTRmYKxyOPQlPhsxG14#/bda7594740fd40299423467b48e9ecf6, provided by JHU CSSE.

Now I am using data from github where they update it now once a day. Link to github repository with data.

For previous version where I used Google Spreadsheets data go to this directory.

Things I have done:

• Did everything I needed to read data from Google Spreadsheets and used data to make some graphs (look here).
• Read data from github repository
• Process data using pandas
• Automated making graph with number of confirmed/deaths/recovered cases for 2 countries with biggest numbers
• Automated making figure with graphs of countries with most confirmed casese (without 2 countries from point above)
• Automated making graph for absolute growth in number of confirmed and deaths/recovered cases
• Automated making interactive plot using bookeh (look here)
• Automated making graph with number of confirmed cases starting from the day when the country passed 100 confirmed cases (for few chosen countries)
• Automated making graph with number of confirmed cases per million citizens

Technologies used:

• Python 3
• Jupyter Notebook
• pandas
• matplotlib
• seaborn
• git
• bookeh

Here are some graphs I made:

Time series data for US

Time series data for Spain

Time series graph for other countries with biggest number of confirmed cases

Absolute growth

Number of confirmed cases by days after passing 100 confirmed cases in country

Number of confirmed cases per million citizens in countries