tushare获取的数据与mysql数据库交互简单范例

weixin_30821731

于 2017-01-19 20:16:00 发布

阅读量105

点赞数

文章标签：数据库 python

原文链接：http://www.cnblogs.com/curious2017/p/6308667.html

版权

#!/usr/bin/python2.7
# -*- coding: UTF-8 -*-

import tushare as ts
import pandas as pd
from sqlalchemy import create_engine

df = ts.get_hist_data('600300').iloc[:,:4]
engine = create_engine('mysql://root:qweqwe@10.0.0.5/stock?charset=utf8')
df.to_sql('tick_data600300',engine,if_exists='append')
df1 = pd.read_sql('tick_data600300',engine)
print df1

转载于:https://www.cnblogs.com/curious2017/p/6308667.html