Aggregating Data from Previous Column in Pandas DataFrame Based on Conditions Using R Programming Language