python公式迭代计算_python-Pandas Dataframe-带条件/行迭代/上一行计算的最小函数

我有一个 dataframe ,其中有一些记录的开始和结束日期：

import pandas as pd

df = pd.DataFrame({'Key': ['A', 'A', 'A', 'A', 'B', 'B', 'B', 'B' ],

'StartDate': ['01/01/2015', '01/01/2016', '06/01/2016','10/01/2017',

'01/01/2015', '01/01/2016', '07/15/2016','10/01/2017'],

'EndDate': ['12/30/2015', '05/31/2016', '09/30/2017', '12/31/2018',

'12/30/2015', '05/31/2016', '09/30/2017', '12/31/2018']})

df = df[['Key', 'StartDate', 'EndDate']]

print(df)

我的输出如下所示：

Key StartDate EndDate

0 A 01/01/2015 12/30/2015

1 A 01/01/2016 05/31/2016

2 A 06/01/2016 09/30/2017

3 A 10/01/2017 12/31/2018

4 B 01/0