使用字典和正则表达式替换Pandas

import pandas as pd

# 创建一个示例DataFrame
data = {'A': ['apple', 'banana', 'orange'],
        'B': ['cat', 'dog', 'elephant']}
df = pd.DataFrame(data)

# 定义要替换的字典
replace_dict = {'apple': 'fruit', 'cat': 'animal'}

# 使用replace()方法进行替换
df.replace(replace_dict, inplace=True)

print(df)

       A        B
0  fruit   animal
1  banana      dog
2  orange  elephant

import pandas as pd

# 创建一个示例DataFrame
data = {'A': ['apple', 'banana', 'orange'],
        'B': ['cat', 'dog', 'elephant']}
df = pd.DataFrame(data)

# 使用正则表达式替换
df.replace(r'^a\w+', 'fruit', regex=True, inplace=True)

print(df)

       A        B
0  fruit   animal
1  fruit      dog
2  orange  elephant