在CSV文件中查找最高平均值

import csv
from qcloud_cos import CosConfig
from qcloud_cos import CosS3Client

# 配置腾讯云COS
secret_id = 'your_secret_id'
secret_key = 'your_secret_key'
region = 'your_region'
bucket = 'your_bucket'
config = CosConfig(Region=region, SecretId=secret_id, SecretKey=secret_key)
client = CosS3Client(config)

# 下载CSV文件
file_name = 'your_file.csv'
local_file = 'local_file.csv'
response = client.get_object(
    Bucket=bucket,
    Key=file_name,
)
response['Body'].get_stream_to_file(local_file)

# 解析CSV文件
data = []
with open(local_file, 'r') as csv_file:
    csv_reader = csv.reader(csv_file)
    for row in csv_reader:
        data.append(row)

# 计算平均值
averages = []
for col in range(len(data[0])):
    total = 0
    count = 0
    for row in range(1, len(data)):
        if data[row][col].isdigit():
            total += int(data[row][col])
            count += 1
    if count > 0:
        average = total / count
        averages.append(average)
    else:
        averages.append(0)

# 查找最高平均值
max_average = max(averages)
max_index = averages.index(max_average)

# 输出结果
print(f"最高平均值：{max_average}")
print(f"对应的列索引：{max_index}")

# 清理临时文件
os.remove(local_file)