Pandas数据导入和导出：CSV、Excel、MySQL、JSON

导入MySQL查询结果：read_sql

import pandas

con = "mysql+pymysql://user:pass@127.0.0.1/test"
sql = "SELECT * FROM `student` WHERE id = 2"

# sql查询
df1 = pandas.read_sql(sql=sql, con=con)
print(df1)
1
2
3
4
5
6
7
8

导入MySQL整张表：read_sql_