Import Data
General Info
Useful Snippets

2.0.6 Import from SQL database

Example:

import pandas as pd
import sqlite3

# Create a database connection
con = sqlite3.connect("path/to/your/databasefile.db")

# Query the databse and load the result data into a DataFrame
DF = pd.read_sql_query("SELECT * from TableName", con)