基于两个公共列合并两个文件，并将空白替换为0

import csv

# 读取第一个文件
file1_data = {}
with open('file1.csv', 'r') as file1:
    reader = csv.DictReader(file1)
    for row in reader:
        file1_data[row['ID']] = row

# 读取第二个文件
file2_data = {}
with open('file2.csv', 'r') as file2:
    reader = csv.DictReader(file2)
    for row in reader:
        file2_data[row['ID']] = row

# 合并两个文件
merged_data = []
for id, row1 in file1_data.items():
    if id in file2_data:
        row2 = file2_data[id]
        merged_row = {**row1, **row2}  # 合并两行数据
        merged_data.append(merged_row)

# 将空白替换为0
for row in merged_data:
    for key, value in row.items():
        if value == '':
            row[key] = '0'

# 将合并后的结果写入新文件
with open('merged_file.csv', 'w', newline='') as merged_file:
    writer = csv.DictWriter(merged_file, fieldnames=merged_data[0].keys())
    writer.writeheader()
    writer.writerows(merged_data)