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
 Make the ratio between two with different X-axis
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

alexduf42

France
2 Posts

Posted - 05/22/2018 :  03:42:35 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Hi, i have two sets of data, but each of them have a different X-axis, one is one measure for one second, and the other one is one measure for ten seconds. I want to know if it is possible to make the ratio between those measures, taking only one value each 10 seconds in the first case.

Thanks

yuki_wu

896 Posts

Posted - 05/22/2018 :  05:15:47 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

Origin has a tool for delete rows according to a user-defined pattern. Please take a look at this knowledge base item and see if this applies to you:
https://www.originlab.com/doc/Origin-Help/reduce-rows
https://www.originlab.com/doc/Tutorials/Data-Reduction

Hope it helps.

Regards,
Yuki
OriginLab
Go to Top of Page

alexduf42

France
2 Posts

Posted - 05/22/2018 :  05:50:13 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thanks the "reduce rows" worked perfectly

Edited by - alexduf42 on 05/22/2018 05:50:31 AM
Go to Top of Page

Drbobshepherd

USA
Posts

Posted - 05/23/2018 :  5:33:40 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Alex,

Instead of reducing rows of the larger set to match the smaller, you could interpolate the smaller set to match the larger. You could:

(1) execute a script using one of the interpolation X-Functions, or

(2) simply use the Set Column dialog. I always liked this technique for its simplicity.

Select the column for the new Y values. Open the Set Column dialog and define Col = oldY(newX), where newX is the column with the X-values I want the column labeled "oldY" interpreted at.

You see, in Origin notation, the parentheses mean to linearly interpolate oldY at the floating point datum newX. Square brackets would mean newX is a counter.

I often did this to generate tables of flight test data when sensors did not have identical sample rates.

DrBob
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