Interpolate

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Interpolate

Description

Interpolate values for a dataset based on numerical sample-value pairs in another dataset and puts the result in a new column.

 

Example

Interpolate time and temperature datasets for sensors A and B with different sampling frequencies:

 

how to interpolate 2 datasets example

 

Inputs

Two.

 

Options

Place the dataset you want to modify as the top input and the dataset you want to sample values from as the bottom input.

Select Top sample column for the column whose values you wish to sample.

Select Bottom sample column for the column that matches the top sample column in the bottom dataset.

Select Bottom value column for the column that contains the values.

Set Interpolation type to the type of interpolation you wish to use.

 

piecewise-interpolation

Piecewise interpolation (image from Wikipedia)

 

linear-interpolation

Linear interpolation (image from Wikipedia)

 

 

Notes

If your sample is below the first sample in the bottom dataset, the first value will be returned.

If your sample is above the last sample in the bottom dataset, the last value will be returned.

Easy Data Transform will try to guess sensible default values for Top sample column, Bottom sample column and Bottom value column based on column contents.

If the first input has a header, this will be used for the output.

The new column is added at the right end. You can change the column order with Reorder Cols and the column name with Rename Cols.

Use Num Format to change the precision of the results.

Messages are shown in the Warnings tab for non-numeric values in either dataset.

Messages are shown in the Info tab for Top sample column outside the range of values in Bottom sample column .

 

See also

Lookup

Join