[R] detecting measurement of specific id in column in R

[Romy Rehschuh]

Dear all,

I hope this is the right way to ask questions.
I have a problem with R regarding the detection of the measurement of a
specific sample_id (see example file attached). I have to substract the
"IN" values (means the air which goes into the chambers) from the values of
"d13C", "ppm_CO2" and "ppm_13CO2" for every single chamber (=sample ID).
The "IN" values have to be the ones which were measured* before *the
measurements of the single chambers in time. I measured "IN" once and then
up to 10 chambers in a row to safe time, then "IN" again, but it can change.
Therefore, searching for the closest "IN" does not work.

Do you have any suggestions? Would it be possible to write a loop for this?
I would really much appreciate your help!

Best, Vicci