从pyodbc读取数据到熊猫

从pyodbc读取数据到熊猫

答案更简短

import pyodbcimport pandascnxn = pyodbc.connect(r'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};'r'DBQ=C:usersbartogredesktopdata.mdb;')sql = "Select sum(CYTM), sum(PYTM), BRAND From data Group By BRAND"data = pandas.read_sql(sql,cnxn)