python - 从 pyodbc execute() 语句返回列名

Question

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。但是我怎么得到

DF.columns = ['ID', 'Nickname', 'Residence']

直接来自光标？该信息是否存储在 cursor 中？

Answer 1

您可以从光标描述中获取列:

columns = [column[0] for column in cursor.description]