当我想要检测我的数据帧中时间之间的重叠时,我得到以下错误:
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)]
目前没有回答
相关问题 更多 >
编程相关推荐