Housekeeping

First, customary importing of packages and data if you haven't already done so from the previous sections."

import pandas as pd
import matplotlib.pyplot as plt

month_int = '08'
day_int = '03'

df = pd.read_csv(f"https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_daily_reports/{month_int}-{day_int}-2021.csv")
df

As you can tell, the table is huge with ~4000 rows. Let us subset our data to just ASEAN countries.

ASEAN_countries_list = ['Brunei', 'Cambodia', 'Indonesia', 'Laos', 'Malaysia', 'Burma', 'Philippines', 'Singapore', 'Vietnam']

asean_df = df[df['Country_Region'].isin(ASEAN_countries_list)]
asean_df.set_index('Country_Region', inplace = True)
asean_df

There are many useless columns as you could tell with NaN. Most likely, we would not need variables such as Lat and Long_. We can thus remove these columns.

asean_df_dropped = asean_df.drop(columns = ['FIPS', 'Admin2','Province_State', 'Last_Update', 'Lat', 'Long_', 'Combined_Key'])
asean_df_dropped

Description of each field (from the github)

1. Country_Region: Country, region or sovereignty name. The names of locations included on the Website correspond with the official designations used by the U.S. Department of State.

2. Confirmed: Total Counts include confirmed and probable (where reported).

3. Deaths: Total Counts include confirmed and probable (where reported).

4. Recovered: Recovered cases are estimates based on local media reports, and state and local reporting when available, and therefore may be substantially lower than the true number. US state-level recovered cases are from COVID Tracking Project.

5. Active: Active cases = total cases - total recovered - total deaths.

6. Incident_Rate: Incidence Rate = cases per 100,000 persons.

7. Case_Fatality_Ratio (%): Case-Fatality Ratio (%) = Number recorded deaths / Number cases.

All cases, deaths, and recoveries reported are based on the date of initial report. Exceptions to this are noted in the "Data Modification" and "Retrospective reporting of (probable) cases and deaths" subsections below.