The pandas module imports read_sql from a submodule; you could try getting it from the submodule:

df = pd.io.sql.read_sql('select * from databasetable', engine, index_col = index)

You could also print pd.__dict__ to see what's available in the pd module. Do you get AttributeError if you try to use other things from the pd module, for example, pd.Series()?

Looking at the pandas.io.sql source, there is no frame_query.

https://github.com/pydata/pandas/blob/master/pandas/io/sql.py

Documentation for pandas.io.sql is here: http://pandas.pydata.org/pandas-docs/stable/io.html#sql-queries

I've looked at pandas documentation from 0.12.0 to latest and the only references to frame_query I've found has been to its deprecation.

I found this SO answer which may address your concerns: https://stackoverflow.com/a/14511960/1703772

However, if you are using pandas version ~ 0.10 when 0.18.1 is available, I have to ask why.

Solution for 2024

I know this question is old, but a recent change to Pandas warrants a new solution

Pandas 2.2.0 appears to have modified how a SQLAlchemy Engine object operates when passed to the con argument for pd.read_sql, pd.to_sql, etc. Unsure if this is intentional.

My project worked perfectly fine with Pandas 2.1.4. When updated to 2.2.0, I receive the AttributeError due to the cursor not being present.

• Solution: Use the connection attribute of a SQLAlchemy Connection object instead of the Engine object directly.

Peep this example:

from sqlalchemy import create_engine
import pandas as pd


# Engine for MS SQL Server using pymssql
conn_url = f"mssql+pymssql://{username}:{password}@{host}/{database}"
engine = create_engine(conn_url)

# Example query
query = 'select id from users'

# Works with pandas<2.2.0
df = pd.read_sql(
    sql=query,
    con=engine,
)

# Works with pandas==2.2.0
with engine.connect() as conn:
    df = pd.read_sql(
        sql=query,
        con=conn.connection
    )

As per comments below, this works with pandas 2.2 for .read_sql(), .read_sql_query(), etc., but does not work for .to_sql() with backends other than SQLite.

Instead of this [ data = pd.read_xlsx ('HRDataset_v14 ().xlsx') ] use

data = pd.read_excel ('filename.xlsx')