python 读取mysql中的文件

# encoding: UTF-8
import pandas as pd
import MySQLdb
mysql_cn= MySQLdb.connect(host, user，passwd，port,db，charset='utf8')
df = pd.read_sql('select * from tablename;', con=mysql_cn)  
print df
mysql_cn.close()
pf = pd.read_csv('C:\\stock data\\asset pricing ncr\\000001.csv',header=None, sep=',',encoding='gbk')
print pf