我如何在特定情况下删除具有员工ID的行

Question

我有一个数据框叫做employee\u change。它包含许多行和许多列。我希望遍历这些行，每次遇到下面if语句中的条件时，我都希望删除与该行具有相同employee id的每一行

下面是每一行的循环

for index, churned in employee_change.iterrows():
    if (churned['stopped_at'] == churned['stopped_at']) and (churned['type_of_termination'] == 'resignation') and (churned['created_at'] <= pd.Timestamp.now() - pd.DateOffset(months=3)):
        employee_change_ThreeMonths = employee_change[~churned['employee_id']]
    elif (churned['stopped_at'] != churned['stopped_at']) and (churned['type_of_termination'] == 'resignation') and (churned['created_at'] <= churned['stopped_at'] - pd.DateOffset(months=3)):
        employee_change_ThreeMonths = employee_change[~employee_id[churned['employee_id']]]

条件应该是好的，但是它给了我-18736的关键误差