Creating a flag
This time you are going to create an actual flag variable that gives a 1 when the emails get a hit on the search terms of interest, and 0 otherwise. This is the last step you need to make in order to actually use the text data content as a feature in a machine learning model, or as an actual flag on top of model results. You can continue working with the dataframe df containing the emails, and the searchfor list is the one defined in the last exercise.
This exercise is part of the course
Fraud Detection in Python
Exercise instructions
- Use a numpy where condition to flag '1' where the cleaned email contains words on the
searchforlist and 0 otherwise. - Join the words on the
searchforlist with an "or" indicator. - Count the values of the newly created flag variable.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Create flag variable where the emails match the searchfor terms
df['flag'] = ____.____((df['clean_content'].___.____('____'.____(____)) == True), 1, 0)
# Count the values of the flag variable
count = df['flag'].____()
print(count)