subtracted_writer.save_column('Wavelength', 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)