将字典值从UTC转换为EDT的时间和pandas中行的对齐

import pandas as pd
from datetime import datetime, timedelta

data = {'time_utc': ['2022-01-01 12:00:00', '2022-01-02 00:00:00', '2022-01-03 06:00:00']}
df = pd.DataFrame(data)

df['time_utc'] = pd.to_datetime(df['time_utc'], utc=True)

df['time_edt'] = df['time_utc'] - timedelta(hours=4)

df['time_edt'] = df['time_edt'].dt.strftime('%Y-%m-%d %H:%M:%S')

print(df)

            time_utc            time_edt
0 2022-01-01 12:00:00  2022-01-01 08:00:00
1 2022-01-02 00:00:00  2022-01-01 20:00:00
2 2022-01-03 06:00:00  2022-01-03 02:00:00