exy02

from sshtunnel import SSHTunnelForwarder
from sqlalchemy.orm import sessionmaker
from sqlalchemy import create_engine
from sqlalchemy import inspect
import pandas as pd

class Postgresql_connect(object):
    def __init__(self, pgres_host, pgres_port, db, ssh, ssh_user, ssh_host, ssh_pkey):
        # SSH Tunnel Variables
        self.pgres_host = pgres_host

exy02

todays_date = date.today().strftime("%m_%d_%Y")

json_df.to_csv(f'/path/to/directory/Georgia_Extract_({todays_date}).csv',index=False)

exy02

json_df[json_df.columns] = json_df[json_df.columns].replace({'"':'',']':'','}':''},regex=True)

for col_name in col_names:
    json_df[col_name] = json_df[col_name].str.split(":",expand=True)[1]

json_df = json_df.sort_values(by=['Test Date','Measure','County'], ascending=[False,False,True])

exy02

json_df = pd.DataFrame(json_list,columns=["new"])
json_df = json_df["new"].str.split(",", expand = True)

col_names = ['Measure','County','Test Date','Positives','Death Count','Cumulative Positives',
             'Cumulative Deaths','Moving Average (Cases)','Moving Average (Deaths)']
json_df.columns = col_names

exy02

json_list = json_extract.split("},{")
json_list = [sub.replace("{", "") for sub in json_list]
json_list = ["["+sub+"]" for sub in json_list]

exy02

json_extract = response_text.split("{t.exports=JSON.parse('[")[1].split("]\')},function(t)")[0]

exy02

sesh = requests.Session()
response = sesh.get('https://ga-covid19.ondemand.sas.com/static/js/main.js')
response_text = response.text