# -*- coding:UTF -8-*-import
osimport
pandas as pd#
检查是否有pymysql这个包存在import
pymysql#
SQLAlchemy本身无法操作数据库,其必须以来pymsql等第三方插件。from
sqlalchemy import create_engine,Sequence,textfrom
sqlalchemy.ext.declarative import declarative_basefrom
sqlalchemy import Column,
Integer,
String,
ForeignKey,
UniqueConstraint,
Indexfrom
sqlalchemy.orm import sessionmaker,
relationship#
设置工作路径os.chdir('E:
/data')#
读取文件sale
= pd.read_csv('sale.csv',encoding
= 'GB18030')'''
sale.csv:
year
market sale
profit
2010
东33912
2641
2010
南32246
2699
2010
西34792
2574
2010
北31884
2673
2011
东31651
2437
2011
南30572
2853
2011
西34175
2877
2011
北30555
2749
2012
东31619
2106
2012
南32443
3124
2012
西32103
2593
2012
北31744
2962
'''#
初始化数据连接数据库的信息host
= yourhostuser
= youridpassword
= yourpassworddb
= yourdatbasenameport
= 3306charset
= 'utf8'#
连接数据库#
pool_recycle控制任何连接的最大连接时长(秒);pool_size连接池的最大连接数,默认5,设置0时为无限制连接数连接;#
max_overflow溢出连接池的最大额外连接数,超过pool_size所设置的连接数的溢出连接数。实际上总的并行连接总数为pool_size
# +max_overflow,设置-1为不设置溢出最大限制,默认为10;pool_timeout等待返回信息时间,默认为30(秒)#
echo类似于python的logging(日志)功能,默认为False
# 'mysql+pymysql',mysql为数据库类型,pymysql为连接方式engine
= create_engine('mysql+pymysql://{user}:{password}@{host}:{port}/{db}?charset={charset}'
.format(user
= user,
host = host,
password = password,
db = db,port
= port,