python连接sql数据库 查询返回结果_python pymysql链接数据库查询结果转为Dataframe实例...

我就废话不多说了，大家还是直接看代码吧！

import pymysql

import pandas as pd

def con_sql(db,sql):

# 创建连接

db = pymysql.connect(host='127.0.0.1', port=3308, user='name', passwd='password', db=db, charset='utf8')

# 创建游标

cursor = db.cursor()

cursor.execute(sql)

result = cursor.fetchall()

#执行结果转化为dataframe

df = pd.DataFrame(list(result))

# 关闭连接

db.close()

#返回dataframe

return df

db = 'database'

sql = 'select * from table'

result = con_sql(db,sql)

print(result.loc[2,2])#打印(3,3)位置的值)

其中，遍历dataframe元素

import pandas as pd

dict=[[1,2,3,4,5,6],[2,3,4,5,6,7],[3,4,5,6,7,8],[4,5,6,7,8,9],[5,6,7,8,9,10]]

data=pd.DataFrame(dict)

print(data)