文章目录
pandas连接数据库
import pymysql
from sqlalchemy import create_engine
sql = 'select * from data'
conn = create_engine('mysql+pymysql://root:[email protected]:3306/test')
pdata = pd.read_sql(sql,conn)
print<
import pymysql
from sqlalchemy import create_engine
sql = 'select * from data'
conn = create_engine('mysql+pymysql://root:[email protected]:3306/test')
pdata = pd.read_sql(sql,conn)
print<