pandas sqlite create table code example

Example 1: sqlite to pandas

import pandas as pd
import sqlite3

con = sqlite3.connect('/Users/mac/Desktop/Python/Baye_stat/productiondisruption/PCI_meat.sqlite')

df = pd.read_sql(<your query here>, con)

Example 2: pandas to sql index

resultDf.to_sql('table_name', engine, schema="schema_name", if_exists="append", index=False)