30+
years serving the scientific and engineering community
Log In
Buy Now
Try Origin for Free
Watch Videos
English
日本語
Deutsch
Toggle navigation
Products
PRODUCTS
Origin
OriginPro
Origin Viewer
All products
Origin vs. OriginPro
What's new in latest version
Product literature
SHOWCASE
Applications
User Case Studies
Video Tutorials
Graph Gallery
Animation Gallery
3D Function Gallery
FEATURES
2D&3D Graphing
Peak Analysis
Curve Fitting
Statistics
Signal Processing
Key features by version
LICENSING OPTIONS
Node-locked(fixed seat)
Concurrent Network (Floating)
Dongle
Academic users
Student version
Commercial users
Government users
Non-Profit users
Why choose OriginLab
Who's using Origin
What users are saying
Published product reviews
Online Store
Get a quote/Ordering
Find a distributor
Apps
Data Import
CSV Connector
Excel Connector
HTML Connector
HDF Connector
NetCDF Connector
Import NMR Data
Import PDF Tables
Google Map Import
Import Shapefile
More...
Graphing
Graph Maker
Correlation Plot
Paired Comparison Plot
Venn Diagram
Taylor Diagram
Volcano Plot
Kernel Density Plot
Chromaticity Diagram
Heatmap with Dendrogram
More...
Publishing
Graph Publisher
Send Graphs to PowerPoint
Send Graphs to Word
Send Graphs to PDF
Send Graphs to OneNote
Movie Creator
Graph Anim
More...
Curve Fitting
Simple Fit
Speedy Fit
Piecewise Fit
Fit ODE
Fit Convolution
Rank Models
Fitting Function Library
Neural Network Regression
Polynomial Surface fit
Global Fit with Multiple Functions
More...
Peak Analysis
Simple Spectroscopy
Peak Deconvolution
Pulse Integration
Align Peaks
Global Peak Fit
PCA for Spectroscopy
2D Peak Analysis
Gel Molecular Weight Analyzer
More...
Statistics
SPC
DOE
Stats Advisor
PCA
RDA
Bootstrap Sampling
Time Series Analysis
Factor Analysis
General Linear Regression
Logistic Regression
SVM Classification
More...
How do Apps work in Origin?
Suggest a New App
Purchase
New Orders
Renew Maintenance
Upgrade Origin
Contact Sales(US & Canada only)
Find a Distributor
Licensing Options
Node-locked(fixed seat)
Concurrent Network (Floating)
Dongle
Academic users
Student version
Commercial users
Government users
Non-Profit users
Why choose OriginLab
Purchasing FAQ
Support
SERVICES
Transfer Origin to new PC
License/Register Origin
Consulting
Training
Renew Maintenance
SUPPORT
Support FAQ
Help Center
Contact Support
Support Policy
DOWNLOADS
Service Releases
Origin Viewer
Orglab Module
Product Literature
Origin Trial
All downloads
VIDEOS
Installation and Licensing
Introduction to Origin
All video tutorials
DOCUMENTATION
User Guide
Tutorials
Python Programming
OriginC Programming
LabTalk Programming
All documentation
Communities
User Forum
User File Exchange
About Us
OriginLab Corp.
News & Events
Careers
Distributors
Contact Us
Contact Us
Log In
All Books
Non-Programming Books
User Guide
Tutorials
Quick Help
Origin Help
Programming Books
X-Function
Origin C
LabTalk Programming
Python
Python (External)
Automation Server
LabVIEW VI
Apps
App Development
Code Builder
License
Orglab
2.2 Data Manipulation
This chapter covers the following topics, and you can refer more X-Functions in these section pages:
X-Functions for Gridding
X-Functions for Matrix
X-Functions for Worksheet
X-Functions for Restructure
In addition, Origin provides a collection of Data Manipulation X-Functions.
Name
Brief
Example
addsheet
Add woksheet(s)/matrix(es) to specified worksheet/Matrix book.
assays
Set up data format and fitting function for Assays Template。
Example
copydata
Copy numeric data.
Example
cxt
Shift the x values of the active curve with different mode.
Example
findreplace
Find and replace cell values in a worksheet or matrix.
levelcrossing
Get x coordinate crossing the given level.
Example
m2v
Convert a matrix to a vector.
Example
map2c
Combine an amplitude matrix and a phase matrix to a complex matrix.
mc2ap
Convert complex numbers in a matrix to amplitudes and phases.
mc2ri
Convert complex numbers in a matrix into their real parts and imaginary parts.
mcopy
Copy a matrix.
mks
Get data markers in data plot
Example
mo2s
Convert a matrix layer with multiple matrix objects to a matrix page with multiple matrix layers.
mri2c
Combine real numbers in two matrices into a complex matrix.
ms2o
Merge (move) multiple matrix sheets into one single matrix sheet with multiple matrixobjects.
newbook
Create a new workbook or matrix book.
Example
newsheet
Create new worksheet.
Example
rank
Decide whether data points are within specified ranges.
reduce_ex
Average data points to reduce data size and make even spaced X.
Example
reducedup
Reduce data to consolidate XY pairs with same X values.
Example
reducerows
Reduce every N points of data with basic statistics.
Example
reducexy
Reduce XY data by sub-group statistics according to X's distribution.
Example
subtract_line
Subtract the active plot from a straight line formed with two points picked on the graph page.
Example
subtract_ref
Subtract on one dataset with another.
Example
trimright
Remove missing values from the right end of Y columns.
v2m
Convert a vector to matrix.
vap2c
Combine amplitude vector and phase vector to form a complex vector.
vc2ap
Convert a complex vector into a vector for the amplitudes and a vector for the phases.
vc2ri
Convert complex numbers in a vector into their real parts and imaginary parts.
vfind
Find all vector elements whose values are equal to a specified value.
Example
vri2c
Construct a complex vector from the real parts and imaginary parts of the complex numbers.
vshift
Shift a vector.
Example
xy_resample
Mesh within a given polygon to resample data.
Example
xyz_resample
Resample XYZ data by meshing and gridding.
Example
Skip Navigation Links
All Books
X-Function
X-Function Reference
Data Manipulation
User Guide
Tutorials
Quick Help
Origin Help
X-Function
Origin C
LabTalk Programming
Python
Python (External)
Automation Server
LabVIEW VI
Apps
App Development
Code Builder
License
Orglab
Programming
X-Function Programming Guide
X-Function Reference
X-Function Tutorials
Data Exploration
Data Manipulation
Database Access
Fitting
Graph Manipulation
Image
Import and Export
Mathematics
Miscellaneous
Plotting
Signal Processing
Spectroscopy
Statistics
Utilities
Vision
Function Details
Alphabetic List to X-Functions
X-Functions for Gridding
X-Functions for Matrix
X-Functions for Worksheet
X-Functions for Restructure
addsheet
assays
clrAllData
copydata
cxt
findreplace
levelcrossing
m2v
map2c
mc2ap
mc2ri
mcopy
mks
mo2s
mri2c
ms2o
newbook
newsheet
rank
reduce_ex
reducedup
reducerows
reducexy
subtract_line
subtract_ref
text2cols
trimright
v2m
vap2c
vc2ap
vc2ri
vfind
vri2c
vshift
wxcat
xy_resample
xyz_resample
English
|
Deutsch
|
日本語
© OriginLab Corporation. All rights reserved.
×
☐
_
Let's Chat