Colorado weekly covid

import requests
from requests_html import HTMLSession
import pandas as pd

mainpage = "https://covid19.colorado.gov/covid19-outbreak-data"
try:
    session = HTMLSession()
    response = session.get(mainpage)
except:
    print('failed to load main page')
    
links = response.html.absolute_links
for l in links:
    if "covid-19_ob_weekly_report" in l:
        print(l)
        url = l

df = pd.read_excel(url)
print(df.head())