如何在Python中将我的CSV文件的UTC转换为CEST

import datetime
import pytz

import csv

# 读取CSV文件
with open('your_csv_file.csv', 'r') as file:
    reader = csv.DictReader(file)
    for row in reader:
        # 解析时间字段
        timestamp = datetime.datetime.strptime(row['timestamp'], '%Y-%m-%d %H:%M:%S')

# 创建UTC时区对象
utc = pytz.utc

# 创建CEST时区对象
cest = pytz.timezone('Europe/Berlin')

# 将UTC时间转换为CEST时间
utc_time = utc.localize(timestamp)
cest_time = utc_time.astimezone(cest)

# 将转换后的CEST时间保存到CSV文件中
with open('output.csv', 'w', newline='') as file:
    fieldnames = ['timestamp']
    writer = csv.DictWriter(file, fieldnames=fieldnames)
    writer.writeheader()
    writer.writerow({'timestamp': cest_time.strftime('%Y-%m-%d %H:%M:%S')})