首先导入需要的包
# 导入需要的包
import pandas as pd
import sqlalchemy import create_engine
初始化数据库,导入数据
db_info = {'user':'root',
'password':'123456',
'host' : 'localhost',
'port': 3306,
database':'mystcok'
}
# engine创建方法一:
engine = create_engine('mysql+pymysql://%(user)s:%(password)s@%(host)s:%(port)d/%(database)s?charset=utf8' % db_info, enconding = 'utf-8')
# engine创建方法二:
engine = create_engine('mysql+pymysql://root:123456@localhost:3306/mystock?charset=utf-8', enconding = 'utf-8')
# 读取本地excel文件
df = pd.read_excel("D:/workfold/机构持仓.xlsx", sheet_name = '2016-2019', converters = {'股票代码: str})
# 将数据存储进mysql数据库
pd.io.sql.to_sql(df, '机构持仓', c