2.2.3.62 wreducerows

1 Menu Information
2 Brief Information
3 Additional Information
4 Command Line Usage
5 X-Function Execution Options
6 Variables
7 Description
8 Example
9 Related X-Functions

Menu Information

Reduce Rows

Brief Information

Reduce worksheet by merging or deleting rows

Additional Information

Minimum Origin Version Required: 9.1 SR0

Command Line Usage

1. wreducerows method:=merge nrows:=3 merge:=ave start:=2;

2. wreducerows method:=hidden;

X-Function Execution Options

Please refer to the page for additional option switches when accessing the x-function from script

Variables

Display Name	Variable Name	I/O and Type	Default Value	Description
Input	irng	Input Range	<active>	Specifies the input data range.
Reduce Method	method	Input int	0	Specifies the reduce method. Option list: 0=del:Delete N rows, then skip M rows Delete N rows, then skip M rows 1=missing:Delete rows with missing values Delete the rows with missing values 2=mask:Delete rows with masked values Delete the rows with masked values 3=merge:Reduce N rows with merged values Merge every N data points into one data point with specified value. 4=hidden:Delete hidden rows Delete hidden rows (e.g. filter out data)
Delete Entire Row	entire	Input int	0	Specifies to reduce rows by deleting whole row based on missing or masked value in reference column. This option is only available when Reduce Method is Delete rows with missing values (method=missing) or Delete rows with masked values (method=merge). And the variable irng is Reference Column Option list: 0=false 1=true
Merge/Delete Rows	nrows	Input int	2	Specifies how many rows to merge or delete. This option is only available when selecting Delete N rows, then skip M rows or Reduce N rows with merged values as Reduce Method.
Skip Rows	skip	Input int	1	Specifies how many rows to skip. This option is only available when selecting Delete N rows, then skip M rows as Reduce Method.
Merge by	merge	Input int	0	Specifies the value to replace the merged data points. This option is only available when selecting Reduce N rows with merged values as Reduce Method. Option list: 0=first:First Point Replaces N data points with the first value of these datapoints. 1=last:Last Point Replaces N data points with the last value of these datapoints. 2=ave:Average Replaces N data points with the average value of these data points. 3=min:Min Replaces N data points with the minimum value of these data points. 4=max:Max Replaces N data points with the maximum value of these data points. 5=sum:Sum Replaces N data points with the sum of these data points. 6=sd:SD Replaces N data points with the standard deviation of these data points.
Starting Row to Merge/Delete	start	Input int	1	Specifies the starting row to merge/delete.
End Row to Merge/Delete	end	Input int	-1	Specifies the end row to merge/delete. Script accessible only.
Output	orng	Output Range	<input>	Specifies the output range.

Description

This X-Function is used to delete rows or merge rows with specified statistics data. See also here.

Example

Example 1

Create a new workbook and import the Origin sample data Gaussian Envelope.DAT which is located in <Origin Program Folder> \Samples\Signal Processing.
Highlight all columns, select menu item Worksheet: Reduce Rows to open wreducerows X-Function dialog. Set the options as below:
Reduce Method: Reduce N rows with merged values

Merge Rows: 10

Merge by: First Point

Starting Row to Merge: 1

Output: <new>
Click OK to merge the rows.

Example 2

Suppose we have a worksheet data. We want to keep rows where col(B)'s value is bigger than 5000 and delete the rest. Run codes below:

//add a filter to col(B) and hide all rows <5000
wks.col2.filter = 1;
wks.col2.filter$="x>5000";
wks.runfilter();
wks.col2.filter=0;
//delete hidden rows
wreducerows method:=hidden;