COVID Cases by Country

Charts and Maps based on COVID data found on Wikipedia.

Background and requirements

I started this project while being stuck at home due to COVID-19. Although I have been fortunate enough to personally not be diagnosed, a few people close to me have. It's scary to just look at the statistics through social media and the news so I wanted to interpret the data on my own. I decided I wanted to analyze the number of new cases reported in each country. To begin I used Python and then sorted the data in the correct form to export it onto an Excel file. Now with the excel file extracted to Tableau, I was able to gather the following data.

Code

The code for the Mining can find in this GitHub post — The code for the COVID data

Environment

• Python

• Jupyter Notebook

• Pandas

• Excel

• Tableau

Conclusion

The first blue map was created using Tableau after extracting the data I decided to use it to see where the most new cases were being found. It did not surprise me that the U.S had the most cases, 25,970,138. However looking at the map, It only shows who has the most and least amount of cases and doesn't give enough information so I decided to go farther. Looking at the bar graph race I created in Flourish(at the top of this page), I can clearly see the change of the total monthly COVID cases from January 2020- January 2021. Though many countries come close and even pass sometimes, the US continues to hold the title of highest number of new cases each month. I acquired this data by using a different dataset of the daily number of new cases and combining them by month. The blue and orange chart shows that while the US had the most cases, also shown in the map, the US also had the highest number of recoveries and few number of deaths compared to the total number of cases. The last graph is the entire total of world COVID cases, deaths, and recoveries. It makes it a lot less scary knowing how little(but still very tragic) deaths there are compared to the recoveries made due to the pandemic.