Data Visualization: How is the world after 10 months of the pandemic
A brief analysis of how the world is today about covid-19
Introduction
In the year 2020, the whole world stopped due to the covid-19 virus, to date (11/23/2020) about 1,338,100 deaths and 55,624,562 confirmed cases worldwide, Such expressive numbers affected and scared people from all over the world. So what is the coronavirus and why has much of the world been quarantined?
Covid-19
According to experts, Covid-19 is an extremely contagious and infectious disease caused by SARS-CoV2. The main symptoms are fever, cough, and tiredness. In most cases, the patient has mild symptoms, but there are symptoms such as severe respiratory failure, pneumonia, organ failure, difficulty in speech movement, and countless other examples. Another problem of this disease is linked to its high contagion, and it is the overcrowding in hospitals because there is a very large number of patients making the situation serious, especially for people who need intensive treatment in hospitals for other reasons or for infected people with covid who are in the risk group.
During these 10 months of the pandemic, there were several situations to analyze, countries that suffered a lot at the beginning due to the population profile being of a high age range such as Spain and Italy, after the control of the disease began a reopening, and according to The Guardian, today, November 2020 there is a risk of entering a second wave. Another important point is about countries like the USA and Brazil that during all pandemic had negative positions against the covid
Database
All data was taken from Data Repository by the Center for Systems Science and Engineering (CSSE) at Johns Hopkins University, you can access them on this link to the repository on Github, This repository is extremely requested by several people who want to do a more in-depth study of data in the world Covid-19. As a recommendation here is a publication of “Dong E, Du H, Gardner L. An interactive web-based dashboard to track COVID-19 in real-time. Lancet Inf Dis. 20(5):533–534. doi:10.1016/S1473–3099(20)30120–1”
Pre-processing and cleaning
Important libraries for the program
import os.path
import sys, json
import requests
import subprocess
import numpy as np
import pandas as pd
import plotly.express as px
from requests.exceptions import RequestException
from requests.adapters import HTTPAdapter
from requests.packages.urllib3.util.retry import Retry
from collections import namedtuple
import matplotlib.pyplot as pltReading the data
df_confirmed = pd.read_csv('time_series_covid19_confirmed_global.csv')df_deaths= pd.read_csv('time_series_covid19_deaths_global.csv')
Transforming data
#Save dates
dates = df_deaths.columns[4:]#Reshape datas
new_df_deaths = df_deaths.melt(id_vars=['Province/State', 'Country/Region', 'Lat', 'Long'],value_vars=dates, var_name='Date', value_name='Deaths')new_df_confirmed = df_confirmed.melt(id_vars=['Province/State', 'Country/Region', 'Lat', 'Long'],value_vars=dates, var_name='Date', value_name='Confirmed')
To read about cleaning data, and merge, please check the repository on Github.
Data visualization
First, let’s take a look at countries like Italy and Spain, which suffered a lot at the beginning of the pandemic, and according to the latest news, a second wave is starting.
As we can see, both countries stabilized the death toll, however, in November the curve of the graph started to grow.
Now we’re going to analyze the USA and Brazil, and for that, we’re going to make a comparison of the death toll of these countries with the rest of the world.
On this world map, we can observe the increase in the number of covid cases over the 10 months of the pandemic. Since the USA and Brazil took the first places they have not left their positions
Conclusion
We are going through difficult times. The observed data do not show positive responses for the moment. Countries like the USA and Brazil need to work according to our current situation, both are top 1 and top 2 of deaths by covid in the world, and the possibility that we are facing a new wave is worrying since we still do not have a good perspective on the global production of a vaccine approved by the public authorities.
