如何根据pandas中的字典映射包含多个字符串的列

import pandas as pd

# 创建包含多个字符串的列的DataFrame
data = {'col1': ['A', 'B', 'C', 'A', 'B'],
        'col2': ['X', 'Y', 'Z', 'X', 'Y']}
df = pd.DataFrame(data)

# 创建字典映射
mapping = {'A': 'Apple', 'B': 'Banana', 'C': 'Cat'}

# 使用map函数进行映射
df['col1_mapped'] = df['col1'].map(mapping)
df['col2_mapped'] = df['col2'].map(mapping)

print(df)

  col1 col2 col1_mapped col2_mapped
0    A    X       Apple           X
1    B    Y      Banana           Y
2    C    Z         Cat           Z
3    A    X       Apple           X
4    B    Y      Banana           Y