I tried to tabulate the number of deaths per capita of COVID-19 (new coronavirus) by country
Purpose
Calculate the number of deaths per capita of COVID-19 by country. It is nonsense to compare the number of infected people because the population and the number of tests differ from country to country. Even if I looked it up, it didn't come out easily, or the date was old, so I made it myself.
Data source
The number of infected people, the number of deaths, and the population of 2018 are summarized by country. There was covid-19-cases-worldwide). Since it was the data as of April 4, 2020, I saved it as "data20200404.csv".
Source code
I tried using pandas for the first time. Convenient.
import pandas as pd
import matplotlib.pyplot as plt
import datetime as dt
coutry_for_analysis = [
'United_States_of_America', 'United_Kingdom', 'France', 'Germany', 'Japan',
'Italy', 'China', 'South_Korea', 'Spain'
]
data = pd.read_csv('data20200404.csv')
data['dateRep'] = pd.to_datetime(data['dateRep'], format="%d/%m/%Y")
fig = plt.figure(figsize=(12, 8))
plt.rcParams['font.family'] = 'Arial'
plt.rcParams['font.size'] = 18
plt.rcParams['xtick.major.width'] = 2.0
plt.rcParams['ytick.major.width'] = 2.0
ax = fig.add_subplot(111)
ax.set_xlabel('Date')
ax.set_ylabel('Cumulative # of Death per population (%)')
ax.spines['top'].set_linewidth(0)
ax.spines['bottom'].set_linewidth(2.0)
ax.spines['left'].set_linewidth(2.0)
ax.spines['right'].set_linewidth(0)
ax.tick_params(axis='x', rotation=45)
ax.set_xlim([dt.date(2020, 3, 1), dt.date(2020, 4, 5)])
for key, grp in data.groupby('countriesAndTerritories'):
if key in coutry_for_analysis:
grp = grp.sort_values('dateRep')
ax.plot(
grp['dateRep'],
100.0 * grp['deaths'].cumsum() / grp['popData2018'],
label=key,
linewidth=2.0,
marker='o',
markersize=6)
ax.legend(ncol=3, bbox_to_anchor=(0., 1.02, 1., 0.102), loc=3, fontsize=18)
plt.savefig('figure.svg', bbox_inches='tight', pad_inches=0.5)
plot
What you think is up to you.
