covid-19_api1.py

import pandas as pd
import numpy as np
import requests

#Request API
url = 'https://corona.lmao.ninja/historical'
r = requests.get(url)
j = r.json()

#Create dataframe
f = pd.DataFrame(j)
ct = f['country'].tolist()
df = pd.json_normalize(f['timeline'])
df['country'] = ct
df = pd.DataFrame(df.set_index(['country']).stack(), columns = ['total'])
df = df.reset_index()
c = df['level_1'].str.split('.', n = 1, expand = True) 
df = df.drop(['level_1'], axis = 1)
df['types'] = c[0]
df['date'] = c[1]