How can we document changed environment that can be measured and influence the parameter we like to measure?

[arendd]

We are currently again faced the problem how can we integrate parameter, which strongly influence our phenotyping experiment, but which we cannot modify or parameterize and also not measure as a kind of result, e.g. weather conditions during the experiment.

I have an example here where we have many samples in the STUDY and one sample represent one plant. In the ASSAY I have for all samples the finally measured plant height, thousand grain weight and some other measured traits. And then we also have the monthly average weather data like temperature or rain for all the years of the complete experiment (it takes several years).

Where and how can we integrate them? Has anybody ideas or some experience with this problem?

To better understand the challenge I added a very reduced and anonymized example of the real data (I skipped the investigation file).

Study File : s_study_1.txt

Assay File : a_assay_1.txt

Wheater data : wheater_data.txt