shixin_zhixing_defend_PINGAN.py 文件源码

def export_pingan_trust16():
    issuers = pd.read_excel('../peace/??????.xlsx',sheetname=[0], header = 0)[0]
    writer = pd.ExcelWriter('time_searies_all.xlsx')
    for company in issuers['name']:
        print(company)
        query = db.pingan_total.find({"name":company},{'_id':0,'name':0}).sort("rptDate" , 1)
        data = pd.DataFrame(list(query))
        data = data[ ['??','??','??','??','??', '??', '??','??', 'rptDate']]
        data = data.rename(columns={"??":"???????","??":"????","??":"?????","??":"???????"})        
        data.to_excel(writer, sheet_name=company)

    writer.save()