I am looking to create a new column called true_water_on in the dataframe trial_A. study_ID randomisation water_on water_off 1 5 2021-01-01 11:00:00 2021-01-01 13:00:00 2021-01-01 18:00:00 2 6 2021-01-02 10:00:00…Read morer – How to copy a value from one column to a new column if column A > column B?