topic Re: Harmonization of X structure in Discussions

Harmonization of X structure

NominalLogNewt5 — Sat, 10 Jun 2023 23:47:06 GMT

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.

Re: Harmonization of X structure

Thierry_S — Fri, 15 Apr 2022 04:41:56 GMT

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,

Re: Harmonization of X structure

NominalLogNewt5 — Tue, 19 Apr 2022 19:19:44 GMT

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