我试图将SQL表放入Pandas DataFrame中,并得到一个游标错误
我只是试图得到一个SQL服务器表到一个熊猫数据框,并从互联网上复制这段代码,显然添加了我的本地详细信息和凭据,例如XXXX等。我认为这工作正常。当我尝试运行下一步时,收到以下消息。
作为纽比,我已经绕了3个小时了,谁能帮帮我!非常感谢
选择 | 换行 | 行号
- import pyodbc
- import pandas as pd
- conn = pyodbc.connect
- (r'DRIVER={ODBC Driver 13 for SQL Server};' +
- ('SERVER={server},{port};' +
- 'DATABASE={database};' +
- 'UID={username};' +
- 'PWD={password}').format(
- server= 'XXXXXX',
- port= 'XXXXXX',
- database= 'XXXXXXX',
- username= 'XXXXXXX',
- password= 'XXXXXXXXX'))
- SQL = "select [PASID], [TeamReferralStartDate], [TeamReferralEndDate], ]TeamCodeDescription] FROM live.tbl_ref_Mart"
- SQL_Query = pd.read_sql_query (SQL ,conn)
上面的代码给了我
选择 | 换行 | 行号
- File "<ipython-input-68-57057e3d73eb>", line 3, in <module>
- SQL_Query = pd.read_sql_query (SQL ,conn)
- File "C:\Users\SMITHAL\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\io\sql.py", line 332, in read_sql_query
- chunksize=chunksize,
- File "C:\Users\SMITHAL\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\io\sql.py", line 1645, in read_query
- cursor = self.execute(*args)
- File "C:\Users\SMITHAL\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\io\sql.py", line 1590, in execute
- cur = self.con.cursor()
- AttributeError: 'builtin_function_or_method' object has no attribute 'cursor'