dataframe to sql 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)
Example 3: 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()
Example 4: SQL to DataFrame
import pandas as pd
import pyodbc
conn = pyodbc.connect('Driver={SQL Server};'
'Server=RON\SQLEXPRESS;'
'Database=TestDB;'
'Trusted_Connection=yes;')
cursor = conn.cursor()
sql_query = pd.read_sql_query('SELECT * FROM TestDB.dbo.Person',conn)
print(sql_query)
print(type(sql_query))