from writer import RowWriter, ColumnWriter from parameters import Parameters params = Parameters() params.use_electrosprayed_parameters() excel_writer = RowWriter() excel_writer.save_row('Mix,Measurement,Result,Diff') subtracted_writer = ColumnWriter() for sheet in params.sheets: print('\n======== ' + sheet + ' ========') grapher = Grapher() grapher.load_sheet_from_excel(params.filename, sheet) grapher.set_params(params) 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