If I know that there were missing values in my email_address column, how can I iterate through it and return the indexes or names of the associated missing values?
I used this code but I don't know what's wrong
surveydf
surveydf.isnull()
for i in surveydf['email_address']:
if surveydf.isnull() is True:
print(surveydf['first_name'])
else:
pass
identify the rows with nan values:
surveydf['email_address'].isna()
use that as a mask:
surveydf[surveydf['email_address'].isna()]['first_name']
create a list out of the 'first_name' column where isna() is True:
list(surveydf[surveydf['email_address'].isna()]['first_name'])