modle.py 文件源码

def getModle():
    fixedEvaluation = pd.read_excel(MODLE_FILE_NAME,sheetname=[0], header = 0, skiprows = [0])
    industryTbl = pd.read_excel(MODLE_FILE_NAME,sheetname=[1], index_col = 2,parse_cols="B:L",header = 3)
    trendTbl = pd.read_excel(MODLE_FILE_NAME,sheetname=[2], header = 2,skiprows=[0])
    fluctuationTbl = pd.read_excel(MODLE_FILE_NAME,sheetname=[3], header = 2,skiprows=[0])
    fixedScoreTble = pd.read_excel(MODLE_FILE_NAME,sheetname=[4], header = 0,skiprows=[0])

    df=pd.read_excel(DATA_FILE,sheetname=[1], header = 0,index_col=0,verbose=True)
    df[1].head().index
    df[1].head().columns

    df[1].head().describe()
    df[1].head().loc[:,['????','?????']]

    for i in range(df[1].head().iloc[1].count()):
        print(df[1].head().iloc[1][i])

    head = df[1].head()    
    head.values[0][1:40].reshape(13,3)