| T O P I C R E V I E W |
| alexduf42 |
Posted - 05/22/2018 : 03:42:35 AM
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 |
| 3 L A T E S T R E P L I E S (Newest First) |
| Drbobshepherd |
Posted - 05/23/2018 : 5:33:40 PM
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
|
| alexduf42 |
Posted - 05/22/2018 : 05:50:13 AM
Thanks the "reduce rows" worked perfectly |
| yuki_wu |
Posted - 05/22/2018 : 05:15:47 AM
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
|
|
|
