Sequential Fit Multiple Files.py

'''
Import each data file in a sample folder into and perform fitting with parameters dialog
to check each fit and generate a sheet with result parameters and stats.
'''
import originpro as op
import os

data_folder = op.path('e') + r'Samples\Batch Processing'
#only to process 3 files
names = ['T285K.csv', 'T305K.csv', 'T345K.csv']
pk_centers=[]
Rsqrs=[]
wdata = op.new_sheet()
graph = op.new_graph(template='scatter')
gl=graph[0]
model = op.NLFit('Gauss')
show_hint=True
for file in names:
    f = os.path.join(data_folder, file)
    print(f'working on {f}')
    wdata.from_file(f, False)
    dp = gl.add_plot(wdata, 1, 0)
    gl.rescale()
    model.set_range(dp.lt_range())
    if show_hint:
        op.messagebox('You can click the Minimize button on the Parameters Dialog to manipulate the graph')
        show_hint = False
    model.param_box()
    model.fit()

    if not op.messagebox('Take a look at the fit', True):
        model.result()#must call either result or report to end the fitting
        break
        
    rr=model.result()
    gl.remove(dp)
    Rsqrs.append(rr['adjr'])
    pk_centers.append(rr['xc'])
    
wdata.get_book().destroy()    
graph.destroy()
wks = op.new_sheet()
wks.from_list(0, names, 'File Name')
wks.from_list(1, pk_centers, 'Peak Center')
wks.from_list(2, Rsqrs, 'R-sqr')