def create_h5(): ## ms = MSSQL(host="localhost",user="******",pwd="123456",db="PythonWeiboStatistics") ## #返回的是一个包含tuple的list,list的元素是记录行,tuple的元素是每行记录的字段 ## ms.ExecNonQuery("insert into WeiBoUser values('2','3')") # ms = MSSQLHelper.getMSSQLInstance() # # #连接 # sqlserverCon = ms.getConnect() # sql = 'SELECT NatureDay,WindCode,IfTradingDay FROM AsIndexComponentZZ500 order by NatureDay,WindCode' # # # resList = ms.ExecQuery(sql) # # for (NatureDay,WindCode,IfTradingDay) in resList: # # print(str(NatureDay) + ' ' + str(WindCode) + ' ' + str(IfTradingDay)) # # #sqlserrver转成h5 # df = pd.read_sql(sql, con=sqlserverCon) # print('df:') # print(df) # exportToHDFStore(df, StockConst.root + '/' + targetAddr + '.h5') hs300df = SourceDataDao.load_h5(StockConst.ROOT + StockConst.HS300H5) zz500df = SourceDataDao.load_h5(StockConst.ROOT + StockConst.ZZ500H5) zz800df = hs300df.append(zz500df) zz800df = zz800df.sort_values(by=['NatureDay', 'WindCode'], ascending=True) SourceDataDao.export_to_hdfstore(zz800df, StockConst.ROOT + StockConst.ZZ800H5)
def print_h5(): df = SourceDataDao.load_h5(StockConst.ROOT + StockConst.ZZ800H5) print(df)
def mergeSignalWithZZ800(): signalDataDf = SourceDataDao.load_signal_data('') indexDf = SourceDataDao.load_h5(StockConst.ROOT + StockConst.ZZ800H5) # signalDataDf = selectSignalByDate(signalDataDf,'2005-01-01','2005-04-08') # hs300Df = hs300Df.loc[(hs300Df['NatureDay'] == '2005-04-08')] mergeSignalWithIndexMain(signalDataDf, indexDf, StockConst.SIGNAL_DATA_BASEDON_ZZ800)