list, dict, tuple，rowproxy 转dataframe

开发十年，就只剩下这套架构体系了！ >>>   

 #res=DbService.getTrainData("F20000",3)#sqlalchemy查询结果--》rowproxy
 #res=DbService.getTestMysqlDb("F20000",3)#MySQLdb查询结果--》tuple
 #res=MetaDataDao.findByDrgId2("F20000")#PymysqlPool封装查询结果---》dict
 #row2Dataframe(res)
 #convert2Dataframe(res)
 #dict2Dataframe(res)

#tuple转dataframe====>mysqlDb查询结果
def convert2Dataframe(data):
    df=pd.DataFrame(list(data),columns=["akc190","yka055","yp_sum","ypzf_yp","hl_sum"])
    ss=df[["yka055","akc190"]]#dataframe数据选取
    print(df)
#dict转dataframe
def dict2Dataframe(data):
    df=pd.DataFrame(data)
    df2=pd.DataFrame.from_dict(data)
    print(df)
#rowproxy转dataframe
def row2Dataframe(data):
    arrs=[]
    for d in data:
        flag1=type(d)
        # todo 转tuple
        res=d._row
        arrs.append(res)
    #todo list[tuple] 转dataframe
    convert2Dataframe(arrs)

#第二种：rowproxy转dataframe
def row2Dataframe(data):
    df=pd.DataFrame(data,columns=["akc190","yka055","yp_sum","ypzf_yp","hl_sum"])
    ss=df[["yka055","akc190"]]#dataframe数据选取