Read data from SQL into Python as a dataframe

Question

I am wanting to read data from SQL into Python as a dataframe. I have the first steps completed successfully, but am not sure how to read it into Python as a dataframe.

This is what I am doing:

 import pandas as pd

 Cap = pyodbc.connect(
 'Driver={SQL Server};'
 'Server=Test\SQLTest;'
 'Database=Cap;'
 'Trusted_Connection=yes;'
)

 

 cursor = Cap.cursor()

 sql =  pd.read_sql_query("SELECT dbo.Catalogs_ID_History$.Location FROM 
 Table 1", Cap)

Any suggestion is appreciated.

moo · Accepted Answer · 2020-10-30 06:28:52Z

1

There is a function in pandas that does exactly what you want, pd.read_sql()

You need to create a connection to the database first. Here's a brief example:

import sqlalchemy
import pandas

engine = sqlalchemy.create_engine('sqlite:///')
df = pd.read_sql('''select sqlite_version();''', engine)

The official documentation is here: https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_sql.html

answered Oct 30, 2020 at 6:28

moo

2,3462 gold badges23 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Read data from SQL into Python as a dataframe

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related