pip install pysqlite3
pip install sqlite
from sqlalchemy import create_engineengine = create_engine('sqlite:///:memory:')dff.to_sql('mySQLtable', con = engine)sqldf = pd.read_sql('mySQLtable', con = engine)sqldf
pip install db-sqlite3
#!/usr/bin/python import sqlite3 conn = sqlite3.connect('test.db') print "Opened database successfully";
$chmod +x sqlite.py $./sqlite.py Open database successfully