默认Dict/Sort by min

2024-04-26 05:21:09 发布

您现在位置:Python中文网/ 问答频道 /正文

提前谢谢你的帮助。到目前为止我有这个代码:

with open("clean_result.csv", "r", encoding="utf-8", errors="ignore") as 
new_data:
reader = csv.reader(new_data, delimiter=',', quotechar='"')
for row in reader:
    if row:
        columns = [row[0], row[1]]
        init_dict.append(columns)

for ean, price in init_dict:
    result[ean].append(price)

然后我用这行得到每个价格的最小值:

maxitems = {ean : min(result[ean]) for ean in result}

电流输出:{'8714789828558':'5,51','332610000182':'15,00','3286010016683':'3,93'(…)}


我想要的是添加第[2]行并获取附加信息,但仅限于最低价格值。你知道吗

所需输出:{'8714789828558':'5,51','A','332610000182':'15,00','B''3286010016683':'3,93','C'(…)}

我试过这个:

for row in reader:
    if row:
        columns = [row[0], row[1], row[2]]
        init_dict.append(columns)

for ean, price, desc in init_dict:
       result[ean].append(price)
       result[ean].append(desc)

maxitems = {ean : min(result[ean]) for ean in result}

但是输出是这样的。一半数据丢失:

{'8714789828558':'A','332610000182':'B''3286010016683':'C'(…)}

我可能误解了什么,所以请任何帮助感谢


Tags: columnscsvinnewfordataifinit
1条回答
网友
1楼 · 发布于 2024-04-26 05:21:09
from operator import itemgetter
from collections import defaultdict

result = defaultdict(list)

for row in reader:
    if row:
        result[row[0]].append((row[1], row[2]))

minitems = {ean : min(prices, key = itemgetter(0)) for ean, prices in result.iteritems()}

相关问题 更多 >