从pyodbc execute()语句返回列名
问题描述：
from pandas import DataFrame
import pyodbc
cnxn = pyodbc.connect(databasez)
cursor.execute("""SELECT ID, NAME AS Nickname, ADDRESS AS Residence FROM tablez""")
DF = DataFrame(cursor.fetchall())
这很好，可以填充我的pandas DataFrame.但是我怎么得到
This is fine to populate my pandas DataFrame. But how do I get
DF.columns = ['ID', 'Nickname', 'Residence']
直接来自光标?这些信息是否完全存储在 cursor 中?
straight from cursor? Is that information stored in cursor at all?
答
您可以从游标描述中获取列:
You can get the columns from the cursor description:
columns = [column[0] for column in cursor.description]