from grapher import Grapher
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)
