在pandas中迭代dataframe查找字符串并生成新列

import pandas as pd
import numpy as np

# 创建一个示例dataframe
data = {'Name': ['John', 'Mike', 'Sarah', 'Jessica'],
        'Age': [25, 30, 35, 40],
        'City': ['New York', 'London', 'Paris', 'Tokyo']}
df = pd.DataFrame(data)

# 定义要查找的字符串
search_string = 'on'

# 使用apply方法迭代每一行，并生成新列
df['Contains_String'] = df['Name'].apply(lambda x: np.where(search_string in x, True, False))

# 打印结果
print(df)

      Name  Age      City  Contains_String
0     John   25  New York             True
1     Mike   30    London            False
2    Sarah   35     Paris            False
3  Jessica   40     Tokyo             True