#导入pandas

import pandas as pd

import numpy as np

#导入SqlAlchemy

from sqlalchemy import create_engine

if __name__ == "__main__":

    #建立数据库引擎

    engine = create_engine('mysql+pymysql://root:mysql@localhost:3306/mymac')

    #写一条sql

    sql = 'select id,name,age,gender from student'

    #建立dataframe

    df = pd.read_sql_query(sql,engine)

    #导入成excel文件  参数为文件名

    df.to_excel('student.xlsx')

#导包

import pandas as pd

if __name__ == "__main__":

    #读取数据集

    df = pd.read_excel('test.xlsx','sheet1')

    print(df)