数据库数据读取和保存

最新推荐文章于 2022-06-22 14:53:06 发布

今天@好日子

最新推荐文章于 2022-06-22 14:53:06 发布

阅读量282

点赞数

本文链接：https://blog.csdn.net/qq_46244390/article/details/104745678

版权

从数据库取数据

import pymysql
from sqlalchemy import creat_engine
import pandas as pd
#建立连接
conn = creating_engine('mysql+pymysql://root:heda123@localhost:3306/test1')
# conn = creating_engine('mysql+pymysql://{}:{}@{}:{}/{}'.formate(user,pw,ip,port,database))
sql = 'select * from female'
#sql = 'select * from'+str(table)
df1 = pd.read_sql(sql,conn)

存数据到数据库

import pymysql
from sqlalchemy import creat_engine
import pandas as pd
import os
os.chdir(r'C:\data\第三章') #修改当前路径
df = pd.read_csv('Delivery.csv')
conn = creating_engine('mysql+pymysql://root:heda123@localhost:3306/test1')
try:
	df.to_sql('testdf',con=conn,index=False,if_exist='replace')
except:
	print('error')