用pandas，if else语句搜索替换Excel

Question

在pandas中用if语句，然后模糊搜索里面的“球”，然后类型这一列含“球“的替换成球类运动，否则else 替换成其他运动

Answer 1

import pandas as pd


df1 = pd.DataFrame(
    {
        "类型": ["篮球", "排球", "足球", "击剑","乒乓球","游泳","铁人三项"],
    }
)
def fun(x):
    if "球" in x:
        return "球类运动"
    else:
        return "其他运动"
    
df1['判断'] = df1['类型'].apply(lambda x: fun(x)) 
df1