Read in SQL files

# Read in the Mullion FlintPro sqlite db

conn = sqlite3.connect(“Simplified_RothC_DB.sqlite”)

# Create a SQL connection to our SQLite database

con = sqlite3.connect(“Simplified_RothC_DB.sqlite”)

cur = con.cursor()

# select one of the tables from

df = pd.read_sql_query(‘SELECT * FROM soil_inputs;’, con)

# close the connection

con.close()

df