某个表五个字段,广告id、位置、投放开始时间(start_time)、投放结束时间(end_time)、创建时间,同广告id、位置时,投放开始时间至投放结束时间段之间有时间重叠时,取最近创建时间对应的记录
例如:
data = {
'广告id': ['ad1', 'ad1', 'ad1', 'ad1', 'ad1', 'ad1', 'ad1','ad2', 'ad2','ad3','ad1','ad1'],
'位置': ['pos1', 'pos1','pos1' , 'pos1','pos1' ,'pos1' ,'pos1' ,'pos2', 'pos2','pos3','pos1','pos1'],
'投放开始时间': ['2024-01-01', '2024-01-05', '2024-01-01', '2024-01-03','2024-01-07','2023-12-07','2024-01-01', '2024-01-12','2024-01-15','2025-03-01','2025-01-01', '2025-01-03'],
'投放结束时间': ['2024-01-10', '2024-01-15', '2024-01-10', '2024-01-10','2024-01-08','2024-01-31','2024-01-10', '2024-01-20','2024-01-16','2025-03-05','2025-01-06', '2025-01-05'],
'
创建时间': ['2024-01-01 10:00:00', '2024-01-02 10:00:00', '2024-01-02 10:11:00','2024-01-03 10:00:00', '2024-01-02 09:00:00', '2024-11-05 10:00:00','2024-12-01 10:00:00', '2024-12-03 10:00:00', '2024-11-02 09:00:00', '2025-01-05 10:00:00','2024-12-07 10:00:00', '2024-12-31 10:00:00'] }
输出结果:
ad1 pos1 2024-01-01 2024-01-10 2024-12-01 10:00:00
ad2 pos2 2024-01-12 2024-01-20 2024-12-03 10:00:00
ad3 pos3 2025-03-01 2025-03-05 2025-01-05 10:00:00
ad1 pos1 2025-01-03 2025-01-05 2024-12-31 10:00:00