covid_totals.py

import csv # Needed to write the output file
import requests # Needed to call the website
from bs4 import BeautifulSoup # The miracle worker that reads the page data

URL = 'https://msdh.ms.gov/msdhsite/_static/14,0,420.html' # Your site
page = requests.get(URL) # Imports the page

soup = BeautifulSoup(page.content, 'html.parser') # Converts the page's html into text

cases = soup.find(id='msdhTotalCovid-19Cases') # Find the table with that id

counties = cases.find_all('tr') # Looks inside the table and makes an array of all the <tr>, or row, elements as counties

counties_totals = [] # Create an empty list to store the totals data

for county in counties:
    data = county.find_all('td') # For each county, make an array of each <td>, or data, element
    county_name = data[0].text # Set county_name as the text insid th 0th data element
    if (county_name != 'County' and county_name != 'Total'): # Gets rid of the first and last row
        
        # For the three numeric cols, if they are blank set to 0
        county_cases = data[1].text
        if (county_cases == ' '):
            county_cases = 0

        county_deaths = data[2].text
        if (county_deaths == ' '):
            county_deaths = 0
           
        county_ltcs = data[3].text
        if (county_ltcs == ' '):
            county_ltcs = 0

        # Make a list for each county, making sure the numbers are actually numbers with int()
        county_data = [county_name, int(county_cases), int(
            county_deaths), int(county_ltcs)]
        
        # Add the county data to the main list
        counties_totals.append(county_data)

# Extremely janky code to test if issaquena if it's still at 0 cases
# and if so, add it

# Set default that issaquena is still not there
issaquena_test = False

# Loop through each county to see if it's Issaquena
for row in counties_totals:
    # if issaquena exists, set to true
    if (row[0] == 'Issaquena'):
        issaquena_test = True

# if it still has no cases add it and sort list
if(issaquena_test == False):
    counties_totals.append(['Issaquena', 0, 0, 0])
    counties_totals.sort(key=lambda x: x[0])

print(counties_totals)

# Write to csv
with open("out.csv", "w", newline="") as f:
    writer = csv.writer(f)
    writer.writerows(counties_totals)

out.csv