#最終統計後的結果,字典格式
products = {}
#讀取的記錄,列表格式
records = []
#讀取文件的每壹行,列表格式
lines = []
#讀取文件,將所有內容寫入列表records
with open("productinfo.txt","r") as f:
#循環讀取
while True:
line = f.readline()
#讀到結尾退出循環
if not line:
break
#如果每行的內容結尾有換行符就舍去
if line[-1] == '\n':
line = line[:-1]
#把每行的數據以逗號為標誌分割
lines = line.split(',')
#把分割的數據追加到列表
records.append(lines)
#遍歷讀到的結果,將結果經過計算後寫入字典products
for record in records:
#每條記錄的第壹項作為字典的KEY,如果這個KEY在字典中就在基礎上增加值
if record[0] in products:
products[record[0]]['total_sales'] += eval(record[2])
products[record[0]]['total_money'] += eval(record[1]) * eval(record[2])
#如果這個KEY不在字典,就設置為record原值
else:
products[record[0]] = {'total_sales':eval(record[2]),'total_money':eval(record[1]) * eval(record[2])}
#排序
sales=sorted(products.items(), key=lambda x:x[1]['total_sales'])
print("最大銷量商品編號:", sales[-1][0],"銷量:",sales[-1][1]['total_sales'])
print("最低銷量商品編號:", sales[0][0],"銷量:",sales[0][1]['total_sales'])