pandas 读取mysql数据的简单方法

#!/usr/bin/python  
# -*- coding: UTF-8 -*-  

import pandas as pd
import numpy as np
import mysql.connector


cnx = mysql.connector.connect(user='xxxx', password='xxxxx',
                              host='xxxx',
                              database='xxxx')



df=pd.read_sql_query("SELECT * FROM table xxx",cnx)

print(df)

使用read_sql_query函数即可，'xxxx'表示实际值，安全起见隐去