Answers for "pandas dataframe to sql"

SQL
2

SQL to DataFrame

import pandas as pd
import pyodbc 
conn = pyodbc.connect('Driver={SQL Server};'
                      'Server=RONSQLEXPRESS;'
                      '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))
Posted by: Guest on May-16-2021
2

pandas to sql index

resultDf.to_sql('table_name', engine, schema="schema_name", if_exists="append", index=False)
Posted by: Guest on August-10-2020
1

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()
Posted by: Guest on September-09-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language