如何使字符串到字典和更新存在的值？ [英] How to make string to dictionary and update values that exist?

问题描述

我打开一个包含以下内容的文件：

I open a file that contains this:

    TransactionNo   Date        CustomerId      PurchasePairs
    -------------   ----        ----------      -------------
    1               09-04-2014  barakobama      potatoes:2.67,sugar:1.98,cereal:5.99,crisps:1.09
    2               11-04-2014  barakobama      parsley:0.76,cereal:3.22
    3               11-04-2014  vladimirputin   bread:0.66,milk:2.87,parsley:1.33

我想要一个字典：

{'vladimirputin': {'milk': 2.87, 'parsley': 1.33, 'bread': 0.66}, 
'barakobama': {'parsley': 0.76, 'sugar': 1.98, 'crisps': 1.09, 
'potatoes': 2.67, 'cereal': 9.21}}

我已经尝试过：

def makeCustomerDictionary(fileNameStr):
    my_dict={}
    file=open(fileNameStr,'r')

    for line in file:
        if line.isdigit():
            line_split=line.split("\t")
            customer_key=set(line_split[2])

问题是我不知道如何在barakobama的价值中添加产品谷物的价格。

The problem is I dont know how to add the price of product "cereal" at barakobama's value.

推荐答案

尝试这样：

#!/usr/bin/env python3

d = {}

with open("in.txt") as i:
    header1 = i.readline()
    header2 = i.readline()

    for line in i:
        fields = line.split()
        d[fields[2]] = dict(item.split(":") for item in fields[3].split(","))

print(d)

输出：

{'vladimirputin': {'milk': '2.87', 'bread': '0.66', 'parsley': '1.33'}, 'barakobama': {'parsley': '0.76', 'cereal': '3.22'}}

如果您想要 float ，请将该行更改为：

If you want floats, change the line to:

d[fields[2]] = dict((item.split(":")[0], float(item.split(":")[1])) for item in fields[3].split(","))

输出：

{'vladimirputin': {'milk': 2.87, 'parsley': 1.33, 'bread': 0.66}, 'barakobama': {'parsley': 0.76, 'cereal': 3.22}}

这篇关于如何使字符串到字典和更新存在的值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！