# -*- coding:utf-8 -*- import pandas as pd import pymysql from sqlalchemy import create_engine ## 加上字符集参数,防止中文乱码 dbconn = pymysql.connect( host="127.0.0.1", database="fight", user="root", password="111111", port=3306, charset='utf8') conn = create_engine('mysql+mysqldb://root:111111@localhost:3306/fight?charset=utf8') # # sqlcmd = "select * from shape_mode_k7f3" # # # data = pd.read_sql(sqlcmd, dbconn) # data.set_index('mkdate') # # print data[data.mkdate>'2018-02-09'][data.secode<'SZ000975']['mkdate'].drop_duplicates() # # defdff = data['2018-02-09':'2018-02-030'] # # print defdff import tushare as ts df1 = ts.get_k_data('600167', ktype='D', start='2017-03-06', end='2017-05-03')#Index([u'date', u'open', u'close', u'high', u'low', u'volume', u'code'], dtype='object') df = ts.get_stock_basics()#Index([u'name', u'industry', u'area', u'pe', u'outstanding', u'totals', # u'totalAssets', u'liquidAssets', u'fixedAssets', u'reserved', # u'reservedPerShare', u'esp', u'bvps', u'pb', u'timeToMarket', u'undp', # u'perundp', u'rev', u'profit', u'gpr', u'npr', u'holders'], # dtype='object') codelist = ['000001','000002','300104'] for code in codelist: print code df = ts.get_hist_data(code=code, start=None, end=None, ktype='D', retry_count=3, pause=0.001) df['code']=code if not df.empty: try: pd.io.sql.to_sql(df,"kkk",con=conn,if_exists='append')#只能说使用createegien的方式 except Exception as e: print 'Error',e else: pass
日周月
最新推荐文章于 2024-08-10 15:27:53 发布