在Python中导入csv文件时转换日期和时间格式

import csv
from datetime import datetime

# 假设CSV文件有两列：'date' 和 'time'
input_file = 'data.csv'
output_file = 'processed_data.csv'

# 定义日期和时间的输入和输出格式
date_format = '%Y-%m-%d'
time_format = '%H:%M:%S'
datetime_format = f'{date_format} {time_format}'

with open(input_file, mode='r', newline='') as infile, open(output_file, mode='w', newline='') as outfile:
    reader = csv.DictReader(infile)
    fieldnames = reader.fieldnames + ['datetime']
    
    writer = csv.DictWriter(outfile, fieldnames=fieldnames)
    writer.writeheader()
    
    for row in reader:
        try:
            # 将日期和时间合并为一个字符串
            datetime_str = f"{row['date']} {row['time']}"
            
            # 解析日期时间字符串
            dt = datetime.strptime(datetime_str, datetime_format)
            
            # 将解析后的datetime对象添加到行中
            row['datetime'] = dt.strftime('%Y-%m-%d %H:%M:%S')
            
            writer.writerow(row)
        except ValueError as e:
            print(f"Error parsing date/time: {e}")

print("CSV processing completed.")