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
