See related video: Data Reduction
Data already existing in a worksheet can be reduced in size using various tools in Origin. The following table provides a summary of available tools. These tools are all accessible from the Analysis: Data Manipulation menu or Worksheet menu when a worksheet is active. Note that some of the tools are also available when a graph window is active.
wdelrows:Works on all or partial columns of the worksheet. A specified number of rows will be skipped each time to reduce the data size.
reducerows:Works with a selection of columns. Replaces every N data points with specified basic statistics value such as average.
wreducerows:Works on all or partial columns of the worksheet. This X-Function combines the features of wdelrows and reducerows.
Works on all or partial columns of the worksheet and reduces worksheet columns by deleting or statistically merging.
Data can also be reduced upon importing a file into a worksheet. The Options Dialog for specific file types, as well as the Import Wizard provide controls for Partial Import where user can import n rows and skip m rows and repeat the pattern, to reduce data size. Later the file can be re-imported in full if desired.