william.py

import pandas as pd

url_confirmed = 'https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_US.csv'
url_deaths = 'https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_deaths_US.csv'
url_tests = 'https://covidtracking.com/api/v1/states/daily.csv'

confirmed = pd.read_csv(url_confirmed)
deaths = pd.read_csv(url_deaths)
tests = pd.read_csv(url_tests)

tests['date'] = pd.to_datetime(
    tests['date'], format='%Y%m%d').dt.strftime("%m/%d/%y")

states = [
    # ['al', 'AL', 'Alabama'],
    # ['ga', 'GA', 'Georgia'],
    ['ms', 'MS', 'Mississippi'],
    # ['sc', 'SC', 'South Carolina']
]

for state in states:
    state_lowercase = state[0]
    state_uppercase = state[1]
    state_name = state[2]

    print(state_lowercase, state_uppercase, state_name)
    print('==========')
    # st_confimed = state_lowercase + "_confirmed"
    state_confimed = confirmed.loc[confirmed['Province_State']
                                   == state_name].reset_index()
    state_deaths = deaths.loc[deaths['Province_State']
                              == state_name].reset_index()
    state_tests = tests.loc[tests['state'] == state_uppercase].reset_index()

    state_confimed = state_confimed.drop(['index'], axis=1)
    state_deaths = state_deaths.drop(['index'], axis=1)
    state_tests = state_tests.drop(['index'], axis=1)

    print(state_name + 'Confirmed')
    print(state_confimed)
    print('--------------')
    print(state_name + 'Deaths')
    print(state_deaths)
    print('--------------')
    print(state_name + 'Tests')
    print(state_tests)

    state_lowercase_col_list = []