shixin_zhixing_defend365.py 文件源码

def export_pingan_trust16():
    issuers = pd.read_excel('../peace/??????.xlsx',sheetname=[0], header = 0)[0]
    writer = pd.ExcelWriter('time_searies.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()

#db = client.companies
#collection = db.total_nums
#insert_record = json.loads(result.to_json(orient='records'))
#ret = db.total_nums.insert_many(insert_record)
# ????
#collection = db.
#df = sued_in_arrears()
#insert_record = json.loads(df.to_json(orient='records'))
#ret = db.collection.insert_many(insert_record)