4.6.3 Reduce Columns

Origin has a tool for reducing data by deleting or merging worksheet columns. Works on all or partial columns of the worksheet and reduces worksheet columns by deleting or statistically merging.


To open this dialog box:

  1. Activate the workbook.
  2. Click Worksheet: Reduce Columns... and open the wreducecols dialog box, which utilizes the wreducecols x-function.

Dialog Options

Recalculate

Controls recalculation of results

  • None
  • Auto
  • Manual

For more information, see: Recalculating Analysis Results

Input Worksheet

The data input range.

For help with range controls, see: Specifying Your Input Data

Reduce Method
  • Delete N columns, then skip M columns
Delete N columns, then skip M columns
  • Reduce N columns with merged values
Merge every N data points into one data point equal to the Merge by value.
Merge/Delete Columns

Option depends on your selection of Reduce Method: Delete N columns... (Delete Columns) or Reduce N columns... (Merge Columns). Number of columns to merge or delete.

Merge by

Available when Reduce Method = Reduce N columns.... Specify value to replace merged data points.

  • First Point
Replace every N data points with the value of the first merged point.
  • Last Point
Replace every N data points with the value of the last merged point.
  • Average
Replace every N data points with the average of the merged points.
  • Min
Replace every N data points with the minimum value of the merged points.
  • Max
Replace every N data points with the maximum value of the merged points.
  • Sum
Replace every N data points with the sum of the merged points.
  • SD
Replace every N data points with the standard derivation of the merged points.
  • Median
Replace every N data points with the median of the merged points.
  • Custom
Use added Custom control to specify quantities (see next).
Custom

Choose quantities from the flyout menu. Multiple quantities should be space-separated (e.g. "ave sd" for average and standard deviation). Each quantity will be output to a separate column and labeled with the Merge by quantity.

Skip Columns

Only available when Reduce Method = Delete N Columns....

Starting Column to Delete/Merge

The starting column to merge/delete.

Output Worksheet

Specify output range. For merge, output columns are labeled with Merge by quantity.

For help with the range controls, see: Output Results