# 创建导包
import pymysql
from pymysql.connections import Connection
import pandas as pd
# 连接数据库
connection = pymysql.connect(
host='localhost',
port=3306,
user='root',
password='123456',
database='py'
)
# 数据库操作
cursor=connection.cursor()
sql="insert into py.pyb(pwd,dname) values(%s,%s)"
# pandas操作,首先创造df,然后根据数据结构,将数据批量放入mysql
data={
"pwd":[1998,1997,9090],
"dname":["淮北","秦安","雁北"]
}
pdf=pd.DataFrame(data)
# 数据插入
for i in range(0,len(pdf),1):
cursor.execute (sql, [pdf.iloc[i,0],pdf.iloc[i,1]])
print("添加成功")
connection.commit()
cursor.close()
connection.close()
Python pandas pandas数据写入数据库
最新推荐文章于 2024-03-20 11:16:24 发布