tim数据帧中的重叠

2024-05-23 18:11:00 发布

您现在位置:Python中文网/ 问答频道 /正文

当我想要检测我的数据帧中时间之间的重叠时,我得到以下错误:

Reindexing only valid with uniquely valued Index objects

我想找出所有数据帧中的重叠时间!不是只有2到3次

periods = df[['START_TIME', 'TIMER_END']].apply(lambda x: (pd.date_range(x['START_TIME'], x['TIMER_END']),), axis=1)
overlap = periods.apply(lambda col: periods.apply(lambda col: col[0].isin(col[0]).any()))
df['overlap_count'] = overlap[overlap].apply(lambda x: x.count() - 1, axis=1)
#overlap_times= overlap_times.loc[~overlap_times.index.duplicated(keep='first')]

overlap_times = df[['DATE','NOM_ENQUETEUR','D10A','overlap_count','START_TIME_1','END_TIME_1','NOM_SUPERVISEUR']]
overlap_times.reset_index(inplace=True, drop=True)
ovppp = overlap_times.loc[(overlap_times.overlap_count == 1 )&(overlap_times.NOM_ENQUETEUR == overlap_times.D10A)]

Tags: 数据lambdadftimecount时间colnom