grapher.sheet.get_measurements('Wavelength'))
for mixture in params.mixtures:
resultMap = {}
column_names = [
c for c in list(grapher.sheet.dataframe) if c != 'Wavelength'
]
for column_name in column_names:
print('\n' + column_name)
grapher.calc_exp_model('Wavelength', column_name)
graph_name = mixture + '_' + column_name
grapher.save_graph(graph_name)
resultMap[column_name] = (grapher.get_subtracted_peak_intensity(),
grapher.subtracted_amount)
excel_writer.save_row(mixture + ',' + column_name + ',' +
str(resultMap[column_name][0]) + ',' +
str(resultMap[column_name][1]))
subtracted_writer.save_column(column_name, grapher.y_data_subtract)
out_filename = 'subtraction_results-' + str(
params.filename.replace('.xlsx', '')) + '.csv'
excel_writer.export_to_excel(out_filename)
data_filename = 'data_after_subtraction-' + str(params.filename)
subtracted_writer.export_to_excel(data_filename, 'subtracted data')
for mixture in params.mixtures:
for measurement in params.measurements:
resultMap = {}
for gas in params.gases:
column_name = params.column_name_function(
mixture, measurement, gas)
print('\n' + column_name)
if column_name in grapher.sheet.measurements:
grapher.calc_exp_model('Wavelength', column_name)
graph_name = gas + '_' + sheet + '_' + mixture + '_' + measurement
grapher.save_graph(graph_name)
resultMap[gas] = (grapher.get_subtracted_peak_intensity(),
grapher.subtracted_amount)
else:
resultMap[gas] = (0, 0)
excel_writer.save_row(
sheet + ',' + mixture + ',' + measurement + ',' +
','.join([str(resultMap[gas][0])
for gas in params.gases]) + ',' +
','.join([str(resultMap[gas][1]) for gas in params.gases]))
out_filename = 'subtraction_results-' + str(
params.filename.replace('.xlsx', '')) + '.csv'
excel_writer.export_to_excel(out_filename)
