Python查询MySQL导出到Excel Pandas

https://www.bilibili.com/video/av462205193/

#查询mysql导出到excel
#导入pandas和pymysql两个包
import pandas as pd
import pymysql
# 连接数据库，传入数据库的配置
conn = pymysql.connect(
    host = '127.0.0.1',
    user = 3306,
    db = 'db_school',
    password='12345678',
    charset = 'utf8'
)
#写入执行sql语句至df中
df = pd.read_sql("""
select * from student_grade
""",con=conn)
# df导出数据至excel
df.to_excel("学生成绩表.xlsx",index=False)

#导出一个数据透视表 quarter季度
db = pd.read_sql("""
   select quarter,course,max(garde),min(grade),avg(grade)
      from student_grade
      group by quarter,course
      """,con=conn).pivot(index="quarter",columns='course')
#每一行是个quarter，每一列是course
df.to_excel("学生成绩表-透视表.xlsx",index=False)