运行一个循环，其中包含查询自动化的三个步骤。

Question

我正在尝试找出一个代码来运行一个查询，这个查询有两个不同的输入，一个片段用来查询并将数据粘贴到相应的国家表和选项卡名上。

ancestor_l = [1,2]
country_l = ['hk','my']
tab_name = ['sh1','sh2']

我希望它创建一个输出输出的循环：

祖先1 开放hksh1 将祖先1粘贴到hksh1 开放mysh1 将祖先1粘贴到mysh1祖先2 openig hksh2 将祖先2粘贴到hksh2 开放mysh2 将祖先2粘贴到mysh2

我的代码如下所示

for anc in ancestor_l:
    print "\n"
    print "ancestor "+ str(anc)
    for tab in tab_name:
        for country in country_l:
            print "opening " + str(country) + str(tab)
            print "pasting ancestor "+str(anc)+" to "+ str(country) + str(tab)

但这将产生以下结果：

ancestor 1
opening hksh1
pasting ancestor 1 to hksh1
opening mysh1
pasting ancestor 1 to mysh1
opening hksh2
pasting ancestor 1 to hksh2
opening mysh2
pasting ancestor 1 to mysh2


ancestor 2
opening hksh1
pasting ancestor 2 to hksh1
opening mysh1
pasting ancestor 2 to mysh1
opening hksh2
pasting ancestor 2 to hksh2
opening mysh2
pasting ancestor 2 to mysh2

如何修复嵌套循环？

Answer 1

下面是一个关于如何改进这个特性的小例子(如jonrsharpe所建议的那样使用zip )：

ancestor_l = [1,2] 
country_l = ['hk','my'] 
tab_name = ['sh1','sh2'] 

for anc, tab in zip(ancestor_l,tab_name): 
    print("\nancestor {}".format(anc))
    for country in country_l:
        print("opening {}{}".format(country,tab))
        print("pasting ancestor {} to {}{}".format(anc,country,tab))

输出：

ancestor 1
opening hksh1
pasting ancestor 1 to hksh1
opening mysh1
pasting ancestor 1 to mysh1

ancestor 2
opening hksh2
pasting ancestor 2 to hksh2
opening mysh2
pasting ancestor 2 to mysh2

Answer 2

就是这里

tab_name_index = 0
for ancestor_l_val in ancestor_l:
    print "\n" 
    print "ancestor "+ str(ancestor_l_val)
    for country_l_val in country_l:
        print "opening "+str(country_l_val)+str(tab_name[tab_name_index])
        print "pasting ancestor "+ str(ancestor_l_val)+" to "+str(country_l_val)+str(tab_name[tab_name_index])
    tab_name_index +=1

输出

ancestor 1
opening hksh1
pasting ancestor 1 to hksh1
opening mysh1
pasting ancestor 1 to mysh1


ancestor 2
opening hksh2
pasting ancestor 2 to hksh2
opening mysh2
pasting ancestor 2 to mysh2