如何使用python脚本在没有pandas的情况下执行vlookup

import csv

# 读取数据表1
table1 = {}
with open('table1.csv', 'r') as file:
    reader = csv.reader(file)
    for row in reader:
        key = row[0]  # 假设第一列为匹配列
        value = row[1]  # 假设第二列为结果列
        table1[key] = value

# 读取数据表2
table2 = {}
with open('table2.csv', 'r') as file:
    reader = csv.reader(file)
    for row in reader:
        key = row[0]  # 假设第一列为匹配列
        value = row[1:]  # 假设从第二列开始为结果列
        table2[key] = value

# 执行vlookup
result = []
for key in table1:
    if key in table2:
        result.append([key] + table2[key])
    else:
        result.append([key] + ['N/A'])  # 如果没有匹配到结果，可以使用'N/A'表示

# 输出结果到文件
with open('result.csv', 'w', newline='') as file:
    writer = csv.writer(file)
    writer.writerows(result)