按照区县编码写进excel中,并把不同区县编码的信息写入到不同的sheet中
bhpt_fail = visitOracle(address , "select * From bhpt_fail")
dist_base_bhpt_fail = pd.DataFrame(bhpt_fail['区县编码'].value_counts()).index
writer = pd.ExcelWriter('按区县编码存放.xlsx',mode='a', engine='openpyxl',if_sheet_exists='new')
for tmp_dict in dist_base_slb_fail:
tmp_dict = str(tmp_dict)
sql = 'select * from system.bhpt_fail where 区县编码 = ' + '\'' + tmp_dict + '\''
df_tmp = visitOracle(address , sql)
df_tmp.to_excel(writer, sheet_name=tmp_dict , index=False)
writer.save()