try: get_analysis = db.get_analysis(analysis_sid) analyses = get_analysis.iloc[:, 0].values for i in range (len(analyses)): analysis_sid = db.analysis_sid(analyses[i]) analysis_information = pd.concat([analysis_information, db.analysis_option(analysis_sid)], axis=0) except: LOGGER.error('Error: Failed to append secondary analysis') file_skeleton(OUTFILE) sys.exit() peril_option = {} analysis_information['PerilOption'] = '' for i in range(len(analysis_information)): if analysis_information['CoversStormSurge'][i]: options = db.get_peril_option(analysis_sid, 'SS') peril_option['SS'] = options.iloc[0].tolist() if analysis_information['CoversPrecipitationFlood'][i]: options = db.get_peril_option(analysis_sid, 'PF') peril_option['PF'] = options.iloc[0].tolist() if analysis_information['CoversThunderstorm'][i]: options = db.get_peril_option(analysis_sid, 'ST') peril_option['ST'] = options.iloc[:, 0].tolist() if analysis_information['CoversInlandFlood'][i]: options = db.get_peril_option(analysis_sid, 'IF') peril_option['IF'] = options.iloc[:, 0].tolist() if analysis_information['CoversTerrorism'][i]: options = db.get_peril_option(analysis_sid, 'TR') peril_option['TR'] = options.iloc[:, 0].tolist() analysis_information['PerilOption'][i] = peril_option
analysis_sid = db.analysis_sid(analyses[i]) analysis_information = pd.concat([ analysis_information, db.analysis_option(analysis_sid) ], axis=0) except: LOGGER.error('Error: Failed to append secondary analysis') file_skeleton(OUTFILE) sys.exit() peril_option = {} analysis_information['PerilOption'] = '' for i in range(len(analysis_information)): if analysis_information['CoversStormSurge'][i]: options = db.get_peril_option(analysis_sid, 'SS') peril_option['SS'] = options.iloc[0].tolist() if analysis_information['CoversPrecipitationFlood'][i]: options = db.get_peril_option(analysis_sid, 'PF') peril_option['PF'] = options.iloc[0].tolist() if analysis_information['CoversThunderstorm'][i]: options = db.get_peril_option(analysis_sid, 'ST') peril_option['ST'] = options.iloc[:, 0].tolist() if analysis_information['CoversInlandFlood'][i]: options = db.get_peril_option(analysis_sid, 'IF') peril_option['IF'] = options.iloc[:, 0].tolist() if analysis_information['CoversTerrorism'][i]: options = db.get_peril_option(analysis_sid, 'TR') peril_option['TR'] = options.iloc[:, 0].tolist() analysis_information['PerilOption'][i] = peril_option