Jul 13, 2022
Read in SQL db from the Audit pack:
#Create a SQL connection to our SQLite database
con = sqlite3.connect(‘Audit_Pack_DataAggregation_220705.db’)
cur = con.cursor()
# select one of the tables from the db
df = pd.read_sql_query(‘SELECT * FROM “0-sites_data”;’, con)
# close the connection
con.close()
df