如何将年和周列与周日期列连接起来

import pandas as pd

# 创建示例数据
data = {'Year': [2021, 2021, 2022],
        'Week': [1, 2, 1],
        'Week_Date': ['2021-01-03', '2021-01-10', '2022-01-02']}
df = pd.DataFrame(data)

# 将Year和Week列转换为日期类型
df['Year_Week'] = pd.to_datetime(df['Year'].astype(str) + df['Week'].astype(str) + '-1', format='%Y%W-%w')

# 连接Year_Week列和Week_Date列
df['Year_Week_Date'] = pd.to_datetime(df['Year_Week']) + pd.to_timedelta(df['Week_Date'].str[-2:].astype(int) - 1, unit='D')

# 打印连接结果
print(df[['Year_Week', 'Week_Date', 'Year_Week_Date']])