我以前有过这个问题。。。试试这个：

# import libraries

from sqlalchemy import create_engine
import pandas as pd

# set login parameters

db = #enter your database schema name here
user = #enter username to login
pw = #type the password here

# connect to database

engine = create_engine("mysql+pymysql://{user}:{pw}@localhost/{db}"
                        .format(user=user,pw=pw, db=db))

# load data from MySQL into a dataframe

df = pd.read_sql_query("Select * from table", engine)

我很肯定这样的事情会奏效的

import pyodbc
import pandas as pd

conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\Users\Ron\Desktop\testdb.accdb;')

SQL_Query = pd.read_sql_query(
'''select
product_name,
product_price_per_unit,
units_ordered,
((units_ordered) * (product_price_per_unit)) AS revenue
from tracking_sales''', conn)

df = pd.DataFrame(SQL_Query, columns=['field1','field2',...])

你可以在这个链接上看到一个很好的例子：https://datatofish.com/sql-to-pandas-dataframe/