如何在pandas中映射不同dataframe basis datetime的列

import pandas as pd

# 创建两个示例dataframe
df1 = pd.DataFrame({'date': ['2022-01-01', '2022-01-02', '2022-01-03'],
                    'value': [1, 2, 3]})
df2 = pd.DataFrame({'date': ['2022-01-01', '2022-01-02', '2022-01-03'],
                    'category': ['A', 'B', 'C']})

# 将df2的category列映射到df1的date列
mapping = dict(zip(df2['date'], df2['category']))
df1['category'] = df1['date'].map(mapping)

print(df1)

         date  value category
0  2022-01-01      1        A
1  2022-01-02      2        B
2  2022-01-03      3        C