5.9 Curve Fitting and Batch Processing with LabTalk
In this tutorial, there are a number of script examples that show how to import data, perform data manipulation, curve fit and batch process multiple sets of data in a loop.
What you will learn
This tutorial will show you how to:
- Import Data
- Perform Nonlinear Regression
- Perform Linear Regression
- Batch Process
Some LabTalk scripts you write will operate on data that has already been imported or entered in your worksheet.
Often times you may need to write LabTalk script to import selected data files.
Every file type supported by Origin for import has its own x-function. For example when you select the Data: Import from File:CSV menu option, choose your data file(s) in the dialog that opens and then make sure the Show Options Dialog checkbox is checked when you click OK, the Import and Export: impCSV dialog will open. The title of this dialog informs you of the name of the x-function used for import.
Another example, to import pCLAMP files use the imppClamp x-function.
Importing a *.dat File
To import an ASCII file, use the impASC x-function.
string fname$ = system.path.program$ + "Samples\Curve Fitting\Multiple Gaussians.dat";
ImpASC Options TreeNode
When you do an import from the menu, you have the option of opening up the Options dialog. The settings in this dialog are accessed by the Treenode variable type.
The impASC x-function has an input variable as follows:
description=Specify the import options in the dialog.
This example makes use of many advanced options of the impASC X-Function. Notice that there is only one semi-colon (following all options assignments) indicating that all are part of the call to impASC.
string fn$=system.path.program$ + "Samples\Spectroscopy\HiddenPeaks.dat";
options.ImpMode:=3 /* start with a new book */
options.Sparklines:=0 /* turn off sparklines */
options.Names.AutoNames:=0 /* turn off auto rename */
options.Names.FNameToSht:=1 /* rename sheet to file name */
options.Miscellaneous.LeadingZeros:=1; /* remove leading zeros */
Fitting your data
Fitting in LabTalk requires the following three x-functions and used in that order:
Begin the fitting process. Define input data, type of fitting function, and input parameters.
This function has many input variables. The only one that has no default value is the func variable, so when you use nlbegin at the very least you need to specify your function. The function you specify will be used to fit the active XY Range, just like when you fit from the Analysis:Fitting:Nonlinear Curve Fit menu.
// initialize fitting the active plot using gauss model
nlbegin iy:=1 func:=gauss nltree:=tt;
// initialize expgrow1 model to fit data with column 1 as X and column 2 as Y
nlbegin iy:=(1,2) func:=expgrow1 nltree:=tt;
The nltree variable is an important one:
description=Tree containing the information of fitting such as parameter values, standard
This function performs the fit calculations. It has two input variables:
description=Number of Iterations
allowed values: 0=lm:LM, 1=s:Simplex
Script Usage Examples:
nlfit 0; // update fit cuves and recalculate chisqr
nlfit 1; // do only one iteration
nlfit; // fit until converge
This x-function ends the fitting process and outputs parameter values.
nlend output:=1 autoupdate:=1
Gaussian Fitting Complete Example
// Begin non-linear fitting, taking input data from Column 1 (X) and
// Column 2 (Y) of the active worksheet,
// specifying the fitting function as Gaussian,
// and creating the input parameter tree named ParamTree:
nlbegin iy:=(1,2) func:=gauss nltree:=ParamTree;
// Optional: let the peak center be fixed at X = 5
ParamTree.xc = 25; // Assign the peak center an X-value of 5.
ParamTree.f_xc = 1; // Fix the peak center (f_xc = 0 is unfixed).
// Perform the fit calculations:
// Optional: report results to the Script Window.
type Baseline y0 is $(ParamTree.y0),;
type Peak Center is $(ParamTree.xc), and;
type Peak width (FWHM) is $(ParamTree.w);
// end the fitting session without a Report Sheet
One way to achieve batch processing is to loop over multiple files or datasets, and within the loop process each dataset by calling appropriate X-Functions and other script commands to perform the necessary data processing.
Batch Nonlinear Curve Fitting
The following example shows how to import 10 files and perform a curve fit operation and print out the fitting results:
// Find all files using wild card
string path$ = system.path.program$ + "Samples\Batch Processing";
// Start a new book with no sheets
// Loop over all files
for(int iFile = 1; iFile <= fname.GetNumTokens(CRLF); iFile++)
// Get file name
string file$ = fname.GetToken(iFile, CRLF)$;
// Import file into a new sheet
// Perform gaussian fitting to col 2 of the current data
nlbegin iy:=2 func:=gaussamp nltree:=myfitresult;
// Just fit and end with no report
// Print out file name and results
type "File Name: %(file$)";
type " Peak Center= $(myfitresult.xc)";
type " Peak Height= $(myfitresult.A)";
type " Peak Width= $(myfitresult.w)";
Batch Linear Fit Analysis
//Select all files using wild card
string strpath$ = system.path.program$ + "Samples\Curve Fitting";
dlgfile group:="Sensor*.dat" init:=strpath$ multi:=1;
//Get the number of files
int nfiles = fname.getnumtokens(CRLF);
//Define a variable to store the slope for linear fit result
//Define a string variable to store the file name
//loop over all selected files
//Get the file name
strFile$ = fname.GetToken(ii, CRLF)$;
//Import the file into new sheet
impASC strFile$ options.ImpMode:=4;
//Use fitlr x-function to fit the dataset and output slope
fitlr (1,2) b:=bslope;
//Print the result string to script window
type -a "Slope for %(strFile$) is $(bslope)";
It is also possible to create an Analysis Template in advance and call the batchProcess X-Function to do batch processing. By doing this, less coding work will be required.
Processing Each Dataset in a Loop
Open the project Samples\Data Manipulation\Setting Column Values.OPJ and switch to the Columns from Other Sheets subfolder.
We will subtract a value, which is the first value of the reference subtracted from the first value of the sample, from the entire sample data. There are multiple transducers, so we can perform this calculation in a loop.
//Reference worksheet range
range rReference = 1!;
//Sample worksheet range
range rSample = 2!;
//Time data range
range rTime = 2!col(Time);
//create a new worksheet
newsheet name:="Corrected Sample";
//fill the first column in this new worksheet with the time data range
wcol(1) = rTime;
//loop over all Transducer columns
range rR = rReference!wcol(ii);
wcol(ii) = rS - ( rS - rR );