Harmonization of X structure

[#1]

Dear all,

I have a set data covering temperature dependent measurements  with the temperature as my designated X-value and the measurement output as Y.

The heating rate differed slightly, therefore the X-data is slightly different for every measurement e.g. 

Measurement 1: T1=20.00 °C, T2= 20.12 °C, T3= 20.25 °C

Measurement 2: T2=19.98 °C, T3= 20.11 °C, T3= 20.26 °C,..

For further evaluation (chemometrics), I want to have the temperature spacing for every measurement in a harmonized structure e.g. 

T1= 20.00 °C, T2= 20.10 °C, T3= 20.20 °C 

and then compute the output via imputation.

Are there any ideas how to get there?

Thanks a lot in advance.

[#2 · Accepted solution]

Hi,

The first option would be to create manual bins for your temperature values, assuming that T1, T2, and T3 do not overlap. However, if you have many temperatures to process, you may want to look into the Column Menu > Utilities > Make Binning Formula. 

Let us know if that addresses your need.

Best,

TS

[#3]

Thanks for the prompt reply. "Make Binning Formula" was a good suggestion.

I solved it now via

1) Binning the temperature with a spacing of 0,2 °C and creating the respective column

2) Creating a new column containing the average (measurement) value for every bin

3) Copying both newly created columns to a new data table

4) Removing the duplicate rows

There might be a cleaner solution but it seems to work that way.

Thanks againg Thierry