The following different date data list, when there is a new data and repeat the above, the earliest record of how to run out of the deadline?

Date key1key2 deadline
12/6/2020 aa
A 12/17/2020 12/6/2020 B
12/6/2020 C a
12/6/2020 D a
12/6/2020 E a
12/7/2020 A c
12/7/2020 B c
12/7/2020 C C
12/7/2020 D c 12/18/2020
12/7/2020 E c 12/29/2020
A 12/30/2020 12/18/2020 B
12/19/2020 D c
12/30/2020 E c
12/31/2020 B a

CodePudding user response:

The import pandas as pd
import numpy as np