答案更简短
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)
答案更简短
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)名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
