給定一個如下所示的 DataFrame: contractIDDate 1982-09-16 (SPZ1982, 1982-12-16 00:00:00)1982-09-17 (SPZ1982, 1982-12-16 00:00:00)1982-09-20 (SPZ1982, 1982-12-16 00:00:00) ...2018-09-27 (SPZ2018, 2018-12-21 00:00:00)2018-09-28 (SPZ2018, 2018-12-21 00:00:00)2018-10-01 (SPZ2018, 2018-12-21 00:00:00)我有重復的contractIDs 并且我想有效地對這些 ID 執(zhí)行操作,如下所示:def query(df, tup, startDate, endDate): ID = tup[0] ExpirationDate = tup[1] panel = df.loc[ID].loc[ExpirationDate].loc[startDate:endDate] return paneldf = pd.DataFrame()print('acquiring daily data...')for tup in contractUse['contractID'].unique(): panel = query(rawData, tup, startDate, endDate) if df.empty: df = panel else: df = df.append(panel, verify_integrity=False)return dfcontractUse上面介紹的DataFrame在哪里。我只想迭代唯一值。當我迭代唯一值時,我需要獲取該唯一值何時開始的索引值,以及該唯一值何時停止的索引值。然后我為我的函數(shù)提供這個startDate和endDate獨特的價值query。有沒有一種快速的方法可以在大熊貓中做到這一點?
添加回答
舉報
0/150
提交
取消