I have a pandas Dataframe consisting of columns Date and Time i.e SL_updatedate_ist, SL_enddate_ist, PH_t2_start_time , PH_t2_end_time and SL_value
I want to create a label by comparing time of PH_t2_start_time , PH_t2_end_time to the SL_updatedate_ist, SL_enddate_ist and create a new column named label next to column value .
Example cycle 1 as label by considering 1st row of PH_t2_start_time , PH_t2_end_time in time between SL_updatedate_ist, SL_enddate_ist.
below are the few images
1st row of Time to be taken from PH_t2_start_time , PH_t2_end_time
Time to be compared with SL_updatedate_ist, SL_enddate_ist
My final result should look some thing like this.
