首页 > 解决方案 > 如何让字典迭代更快

问题描述

我写了这段代码,但它很慢。有没有办法让我的代码执行得更快?

mirTable 有 8789 行,tgtTable 有 9100 行。执行此代码需要 5 分钟

    mirTable = mirTable.to_dict()
    tgtTable = tgtTable.to_dict()
    for mn in range(mLen):
        m = 0
        for lk in range(tLen):
            g = ""
            h = ""
            if mirTable['UPDATE_KEY'][mn] != tgtTable['UPDATE_KEY'][lk]:
                m = 9
                if row.INTERFACE_KEY == None:
                    g = str(mirTable['CONTACT_SRC_ID'][mn])
                else:
                    g = row.INTERFACE_KEY
                    g = str(mirTable[g][mn])
                if row.INTERFACE_KEY_2 != None:
                    c = row.INTERFACE_KEY_2
                    h = "_" + str(mirTable[c][mn])
                else:
                    h = None
                a = ""
                if row.INTERFACE_KEY_2 == None:
                    a = "drft_" + g + "_" + row.INTERFACE_TYPE + "_" + str(curDate) + ".xml"

                else:
                    a = "drft_" + g + h + "_" + row.INTERFACE_TYPE + "_" + str(curDate) + ".xml"

        if m == 9:

            f.append({i:mirTable[i][mn] for i in (mirTable.keys())})
            p.append(mirTable['UPDATE_KEY'][mn])
            xml_FileName.append(a)
    t1 = time.time()
    print(t1-t0)

标签: python-3.xloopsdictionary

解决方案


推荐阅读