python - 为什么 python 字典给我Keyerror？

Question

我正在读取 Excel 文件并使用文件 a.py 中的以下代码创建字典。

productNo = int(worksheet.cell_value(curr_row, 1))
    print "Product No :" + str(productNo)
    products[productNo] = {}

    while curr_cell < num_cells:
        curr_cell += 1
        header =  str(worksheet.cell_value(0, curr_cell))


        # Cell Types: 0=Empty, 1=Text, 2=Number, 3=Date, 4=Boolean, 5=Error, 6=Blank
        cell_type = worksheet.cell_type(curr_row, curr_cell)
        #print '    ',curr_cell,' <-> ', cell_type
        cell_value = worksheet.cell_value(curr_row, curr_cell)
        if cell_type == 0 or cell_type == 6:
            products[productNo][header] = ""
        if cell_type == 1:
            #products[productNo] = {header :cell_value}
            products[productNo][header] = cell_value
        elif cell_type == 2:
            cell_value = int(cell_value)
            print "Header " + header
            products[productNo][header] = cell_value
        elif cell_type == 3:
            products[productNo] = {header :cell_value}
        elif cell_type == 4:
            products[productNo] = {header :cell_value}

在文件 main.py 中，我通过将变量 products 作为字典传递来调用上面编写的代码(在函数中)和 catalouge.readExcel('D:/Personal/CatalogNo_1134.xls', products) 。

当转储它时，我得到所有的键和值。

print "Dump " + str(products)

    print  products.keys()

    print products['28852']['ProductNo']
    print products['28852']['Style']


Dump {28852: {'Category': u'Party Wear', 'Style': u'Designer', 'ProductNo': 28852, 'ProductGroup': u'Salwar Kameez', 'CatalogNo': 1134, 'ProductType': u'Salwar Kameez', 'SubCategoryDefinition': '', 'Fabric': u'Faux Georgette', 'MinWebPrice': 3395, 'Description': u'Capture The Exuberance Of Womanhood In Its Full Glory That Will Bring Out Your Fragility And Femininity. Genuine Magnificence Will Come Out Through The Dressing Style With This Off White Faux Georgette Salwar Kameez. The Appealing Lace|Resham Work Through The Attire Is Awe-Inspiring.', 'OptionOfSleeves': '', 'Rate/FreeSize': 2095, 'XLRate': 0, 'GenericName': u'Dress Material', 'SizeAvailable': u'Not Applicable', 'MaxLengthCholi': '', 'ItemTag': u'Enigmatic Off White Salwar Kameez', 'SubCategory': u'Other - Party Wear', 'Description of Blouse/Choli/Bottom': u'Paired With A Matching Bottom', 'Colour': u' Off White', 'Work': u'Lace|Resham', 'ExpressQty': 0, 'Occasion': u'Christmas,Diwali,Eid,Festival,Kitty Party,Mehendi,Navratri,Party Wear,Sangeet,Wedding', 'Weight': 1, 'Description of Dupatta': u'Comes With A Matching Dupatta', 'DeliveryDays': 8}, 28853: {...}}

键是

[28852, 28853, 28854, 28855, 28856, 28857, 28858, 28859, 28860, 28861, 28862, 28863]

当我使用产品访问它时['28852']

Traceback (most recent call last):

    print products['28852']['ProductNo']
KeyError: '28852'

Answer 1

您正在访问 str 28852，而 key 是整数。请使用28852访问。