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

--

--

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Melanie Zeppel

Women in AI: Agribusiness winner - 2022 Superstar of STEM 2022-2023 Scopus Sustainability Researcher of the Year - 2019