Setting Column Values in Origin – the Programmers Way!

Do the following

1. Select any of the columns by clicking on its title label
2. Right click and invoke the “Set Values” dialog box
3. Click on the little arrow to the bottom right (“Show Scripts”)
4. In the “Before Formula Scripts” text box, type in the following:
   // set your reference paramters
   aRef = 10;
   aCorrection = 0.01;
   // loop over columns – say from column 2 to column 25 – you may need to start at column 2
   // since column 1 usually holds the data corresponding to the independent variable
   loop(i, 2, 25) {
   wcol(i) /= aRef;
   wcol(i) += aCorrection;
   }
   
5. Click “Apply” or “OK”
   

Voila!

Origin is a “professional data analysis and graphing software for sicnetists and engineers”. More often than not, I find myself importing tons of data into worksheets. Most of the time, I would be comparing analytical (yes, some folks on this planet still do analytical work) and numerical data. Without loss of generality, most analytical solutions produce dimensionless data which will eventually end up being compared to numerical or experimental results. Of course, the numerical or experimental results need to be normalized accordingly. Bottom line, you have to go through every column of external data and do what needs to be done: divide, multiply, subtract etc…

In Origin, once you have some values in a column, you can right click on that column and select “Set Column Values” and enter some formula (e.g. Col(A) = Col(A)*10 + 2). The brute force approach is to go over every column, and type in the formula over and over again. So for Column B, you’ll have Col(B) = Col(B)*10 + 2 and so on.

Fortunately, Origin is amazingly modular and allows you to put in your formulas as a script. So here’s the idea: How about writing a script that loops over all the desired columns and sets the values accordingly?

The nice thing about this is that you can use the usual C operations: *=, /=, +=, and –=.

For online video tutorials and goodies related to Origin, check the OriginLab Website.

Enjoy programming!

Update: A couple of graphs made using Origin to illustrate the quality of the resulting graphs. Note that the default graph template used by Origin may look just like an excel graph. You will have to customize your graph to match the look that you are looking for, and of course, reuse the template you have created.

Cite as:
Saad, T. "Setting Column Values in Origin – the Programmers Way!". Weblog entry from Please Make A Note. https://pleasemakeanote.blogspot.com/2009/02/setting-column-values-in-origin.html