pandas to sqlite database code example

Example 1: pandas to sql index

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

Example 2: how to transfer pandas datafra,e to sqlite

import sqlite3 as db
# Create your connection.
conn = db.connect('connection_name')
df.to_sql(name='table_name', con=conn)