python3.X访问mysql，并读取为DataFrame

import pandas as pdimport pymysqlcon = pymysql.connect(host = "localhost", user = "root", password = '12', db = "test", charset='utf8')#charset用于修正中文输出为问号的问题sql = "select * from score"df = pd.read_sql(sql, con)