如何根据pandas中的其他列映射这些值？

import pandas as pd

# 创建一个示例DataFrame
data = {'A': [1, 2, 3, 4, 5],
        'B': ['apple', 'banana', 'apple', 'banana', 'apple'],
        'C': ['red', 'yellow', 'green', 'red', 'green']}
df = pd.DataFrame(data)

# 创建映射字典
mapping = {'apple': 'fruit', 'banana': 'fruit', 'red': 'color', 'yellow': 'color', 'green': 'color'}

# 使用map()函数进行映射
df['B_mapped'] = df['B'].map(mapping)
df['C_mapped'] = df['C'].map(mapping)

print(df)

   A       B       C B_mapped C_mapped
0  1   apple     red    fruit    color
1  2  banana  yellow    fruit    color
2  3   apple   green    fruit    color
3  4  banana     red    fruit    color
4  5   apple   green    fruit    color