I have this dataframe:

How do I edit all the cells containin "@"?

So the result should be like this:

Thank you!

CodePudding user response：

Use loc:

df.loc[df['Phone / Mail'].str.contains('@'), 'Phone / Mail'] = 'Please fill in Phone Number'

Or np.where:

df['Phone / Mail'] = np.where(df['Phone / Mail'].str.contains('@'), df['Phone / Mail'], 'Please fill in Phone Number')

Just filter the occurrences of the @ sign.