The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Remove data points of desired range from XYZ data
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

NickB12345

2 Posts

Posted - 09/24/2013 :  5:49:54 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. and Service Release (Select Help-->About Origin): 8.6
Operating System: Windows 7

Hello

I was wondering if there was an easy way to remove data points of a desired range from a XYZ data set. More specifically, I have XYZ data, centered at the origin, and I would like remove the all data points that are within a certain distance from the origin. Is this possible?

I know if this were a 2D data set I could easily accomplish this using the Cluster Tool, but there doesn't seem to be a 3D analog of the cluster tool, at least in Origin 8.6..... Perhaps its time to upgrade?

Sam Fang

293 Posts

Posted - 09/24/2013 :  11:20:34 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Suppose XYZ data are in columns A, B, C, and you want to remove points whose distance is within 10 from the origin. It can be done as follows:

1. Add a column,and select Set Column Values, and set the column (set Recalculate as None):
Distance3D(col(A),col(B),col(C),0,0,0)<=10?1/0:col(C)

2. Then select Worksheet: Reduce Rows from Origin menu. And choose Delete rows with missing values as Reduce Method.

You can also use other tools in Origin, e.g. Worksheet Query.

In 9.0, even you can use Data Filter tool.

Sam
OriginLab Technical Services

Edited by - Sam Fang on 09/24/2013 11:25:38 PM
Go to Top of Page

NickB12345

2 Posts

Posted - 09/25/2013 :  3:43:18 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thanks Sam, that did the trick!

Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000