python显示为0值的值，最大最大值，名称为txt.file

Question

我编写了代码来查找具有最小值、最大值和 0 值的材料，它仅查找最小值和最大值，但我还需要显示最小值和最大值的名称。我还需要显示 0 值。我有ma​​terial.txt，其中有销售该材料的材料名称、数量、价格、公司：

Cement,123,10000,some company
Metall,122,11000,some another company

以下是代码：

def how_many_materials():
    print("Material with min val:")
    with open('material.txt', "r", encoding="UTF8") as csvfile:
        data = csv.reader(csvfile, delimiter=',')

        minval = []
        maxval = []
        for i in data:
            minval.append(i[1])
            maxval.append(i[1])

    print(min(minval))

    print("Material with max val:")
    print(max(maxval))
    print("Materials with 0 quantity:")

Answer 1

我们还需要添加材料名称：

import csv
def how_many_materials():
    with open('material.txt', "r", encoding="UTF8") as csvfile:
        data = csv.reader(csvfile, delimiter=',')

        minval = []
        maxval = []
        zeroquantity = []
        for i in data:
            minval.append((i[0],i[2]))
            maxval.append((i[0],i[2]))
            if i[1]==0:
                zeroquantity.append(i[0])
        
    print("Material with min val: {0} - {1}".format(min(minval,key=lambda x:x[1])[0],min(minval,key=lambda x:x[1])[1]))
    print("Material with max val: {0} - {1}".format(max(maxval,key=lambda x:x[1])[0],max(maxval,key=lambda x:x[1])[1]))
    print("Materials with 0 quantity: ",len(zeroquantity))
    for i in zeroquantity:
        print(i)

how_many_materials()

样本输出将是：

Material with min val: Cement - 10000
Material with max val: Metall - 11000
Materials with 0 quantity:  0