Screen Link:
https://app.dataquest.io/m/348/guided-project%3A-clean-and-analyze-employee-exit-surveys/4/filter-the-data
My Code:
dete_resignations=dete_survey_updated[dete_survey_updated["separationtype"]=="Resignation-Other reasons" or dete_survey_updated["separationtype"]=="Resignation-Other employer" or dete_survey_updated["separationtype"]=="Resignation-Move overseas/interstate"]
What I expected to happen:
I thought through boolean indexing like this, I could select rows from dete_survey_updated where column separationtype is either Resignation-Other reasons or Resignation-Other employer or Resignation-Move overseas/interstate
What actually happened:
ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all().