使用pandas读取数据库时,由于存储有汉字,开始读取时发现汉字被乱码显示,如下:
In [70]: import pymysql
In [71]: conn = pymysql.connect(host='localhost', port=3306, user='root', password='123456', db='test')
In [72]: import pandas as pd
In [73]: data = pd.read_sql('select * from obj_infos', conn)
In [74]: dat