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
 All Forums
 Origin Forum
 Origin Forum
 Remove data points of desired range from XYZ data

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
NickB12345 Posted - 09/24/2013 : 5:49:54 PM
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?
2   L A T E S T    R E P L I E S    (Newest First)
NickB12345 Posted - 09/25/2013 : 3:43:18 PM
Thanks Sam, that did the trick!

Sam Fang Posted - 09/24/2013 : 11:20:34 PM
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

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000