从一个CSV中选取一个值列表，并获取该列表在另一个CSV中的值的计数

import csv

# 读取第一个CSV文件
with open('file1.csv', 'r') as file1:
    reader1 = csv.reader(file1)
    data1 = list(reader1)

# 提取值列表
value_list = [row[0] for row in data1]

# 读取第二个CSV文件
with open('file2.csv', 'r') as file2:
    reader2 = csv.reader(file2)
    data2 = list(reader2)

# 计算值的计数
count_dict = {}
for row in data2:
    if row[0] in value_list:
        if row[0] in count_dict:
            count_dict[row[0]] += 1
        else:
            count_dict[row[0]] = 1

# 输出计数结果
for value, count in count_dict.items():
    print(f"{value}: {count}")