cong bar

本文主要是介绍cong bar，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

# -*- 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')
connt = create_engine('mysql+mysqldb://root:111111@localhost:3306/fight?charset=utf8')# sqlcmd = "select * from code"
# #
# #
# data = pd.read_sql(sqlcmd, dbconn)

import tushare as tsts.get_stock_basics()
con = ts.get_apis()
df = ts.get_stock_basics()
codelist = df.index
#codelist = list(data['code'])
for code in codelist:print codedf = ts.bar(code=code,conn=con,freq='D',start_date='2018-04-26',end_date='2018-04-27',adj='qfq',ma=[5,10,20],factors=['tor'],retry_count=3)if type(df) == pd.DataFrame:df['code']=codeif df.shape[0]>0:try:pd.io.sql.to_sql(df,"kankan",con=connt,if_exists='append')#只能说使用createegien的方式
                        except Exception as e:print 'Error',eelse:pass
                else:print 'Data is not enough'
        else:print 'No data @', code

这篇关于cong bar的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---