I have a large dataset consisting of gastrointestinal tract pH values that are recorded every 10 minutes over a period of up to 150 days. There are about 70 patients in the group, representing 4 experimental treatment groups. Overall there are about 800,000 lines of data, so a bit challenging to interpret. Consequently, I would like to compare the treatments with respect to the proportion of time that measurements stay below certain critical pH thresholds. Example data are included in the attached file. Any thoughts on how to do this? Note that the measurement periods are not the same for all patients, hence the desire to look at this as the proportion of overall time under the specified pH values.
... View more