csv文件-查找谁拥有最小值和最大值

import csv

def find_min_max(csv_file):
    min_value = float('inf')
    max_value = float('-inf')
    min_owner = ''
    max_owner = ''

    with open(csv_file, 'r') as file:
        reader = csv.reader(file)
        next(reader)  # 跳过标题行

        for row in reader:
            value = float(row[1])  # 假设数值在第二列
            owner = row[0]  # 假设所有者在第一列

            if value < min_value:
                min_value = value
                min_owner = owner

            if value > max_value:
                max_value = value
                max_owner = owner

    return min_owner, min_value, max_owner, max_value

# 使用示例
csv_file = 'data.csv'  # 替换成实际的CSV文件路径
min_owner, min_value, max_owner, max_value = find_min_max(csv_file)

print(f'最小值所属者: {min_owner}, 值: {min_value}')
print(f'最大值所属者: {max_owner}, 值: {max_value}')