python获取csv某一列最小值,查找从CSV文件Python生成的列表的最小值和最大值

最新推荐文章于 2023-02-09 17:33:50 发布

A-蓝色弧线

最新推荐文章于 2023-02-09 17:33:50 发布

阅读量1k

点赞数

文章标签： python获取csv某一列最小值

该博客介绍如何使用Python从CSV文件中读取数据，并计算每行数据的最小值和最大值。通过示例代码展示了如何处理CSV文件，计算平均值并按特定列排序，最后将结果打印出来。示例包括使用列表推导式和内置函数`min`和`max`来找到每行的最小和最大数值。

摘要由CSDN通过智能技术生成

I am trying to find the MIN and MAX values for each row of a CSV file and append them to the next position in the list, positions 5 and 6. I have managed to calculate the average, append this to the forth position and output this in highest to lowest however, I am struggling to work out how to find the MAX and MIN values of each row so I can do the same - highest to lowest. The original CSV is formatted: Fred,56,78,99 with each user on a new line.

Any help would be appreciate.

import csv

import operator

sample = open("sampleData.txt", "r")

csv1 = csv.reader(sample, delimiter = ',')

sort = sorted(csv1,key=operator.itemgetter(0))

for i in range( 0, len(sort)):

sort[i].append((int(sort[i][1]) + int(sort[i][2]) + int(sort[i][3])) / int(len(sort[i])-1))

sort = list(reversed(so