dataframe to sqlite code example
Example 1: convert sqlite table to pandas dataframe
import sqlite3
import pandas as pd
dat = sqlite3.connect('data.db')
query = dat.execute("SELECT * From <TABLENAME>")
cols = [column[0] for column in query.description]
results= pd.DataFrame.from_records(data = query.fetchall(), columns = cols)
Example 2: 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 3: how to transfer pandas datafra,e to sqlite
import sqlite3 as db
conn = db.connect('connection_name')
df.to_sql(name='table_name', con=conn)
Example 4: df to sql pandas sql achemy
from sqlalchemy import create_engine
engine = create_engine('sqlite://', echo=False)
df.to_sql('users', con=engine)
engine.execute("SELECT * FROM users").fetchall()