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))