text_plain_output_1.png
import pandas as pd

import pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)

import requests

import requests
url = 'https://www.worldometers.info/coronavirus/#countries'
header = {'User-Agent': 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.75 Safari/537.36', 'X-Requested-With': 'XMLHttpRequest'}
r = requests.get(url, headers=header)
dfs = pd.read_html(r.text)
df = dfs[0]
time_series = pd.read_csv('../input/corona-virus-report/covid_19_clean_complete.csv', parse_dates=['Date'])

df.isnull().sum()

df.rename(columns={'Country,Other': 'Country'}, inplace=True)
df.rename(columns={'Serious,Critical': 'Serious'}, inplace=True)
df.rename(columns={'Tot Cases/1M pop': 'TotalCases/1M'}, inplace=True)
time_series.rename(columns={'Country/Region': 'Country'}, inplace=True)
df.drop('#', axis=1, inplace=True)

df.dtypes

dataframe = df.iloc[1:216, :-1]
dataframe.style.background_gradient(cmap='Reds')