将两个Pandas列转换为yyyy-mm-dd HH:MM:SS

import pandas as pd

# 创建一个示例数据集
data = {'date': ['2022-01-01', '2022-02-01', '2022-03-01'],
        'time': ['10:00:00', '11:30:00', '12:45:00']}
df = pd.DataFrame(data)

# 将date列和time列合并为一个datetime列
df['datetime'] = pd.to_datetime(df['date'] + ' ' + df['time'])

# 将datetime列转换为指定格式的字符串
df['formatted_datetime'] = df['datetime'].dt.strftime('%Y-%m-%d %H:%M:%S')

# 打印转换后的结果
print(df['formatted_datetime'])

0    2022-01-01 10:00:00
1    2022-02-01 11:30:00
2    2022-03-01 12:45:00
Name: formatted_datetime, dtype: object