问

两张表的笛卡尔积

WEIAIXINGJIANMENG 发布于 2023-02-13 16:37

我在格式中有以下表格

{str:list of str}  
table1 = {key1:['1','2','3'], key2: ['3','4','5']}  
table2 = {key3:['6','7','8','9'], key4:['9','10','11','12']}

现在我需要在不使用itertools或sql命令的情况下获得两者的笛卡尔积.

我基本上需要新表:

new_table = {key1:['1','1','1','1','2','2','2','2','3','3','3','3'], 
             key2: ['3','3','3','3','4','4','4','4','5','5','5','5'],
             key3: ['6','7','8','9','6','7','8','9'],
             key4: ['9','10','11','12','9','10','11','12']}

我该怎么做呢？

1 个回答

table1 = {"key1":['1','2','3'], "key2": ['3','4','5']}  
table2 = {"key3":['6','7','8','9'], "key4":['9','10','11','12']}
n1, n2 = 4, 2
r1 = {k:[i for i in v for j in range(n1)] for k, v in table1.items()}
r2 = {k:v * n2 for k, v in table2.items()}
r1.update(r2)
print r1

产量

{'key3': ['6', '7', '8', '9', '6', '7', '8', '9'], 'key2': ['3', '3', '3', '3', '4', '4', '4', '4', '5', '5', '5', '5'], 'key1': ['1', '1', '1', '1', '2', '2', '2', '2', '3', '3', '3', '3'], 'key4': ['9', '10', '11', '12', '9', '10', '11', '12']}

2023-02-13 16:39 回答

包子F3R

撰写答案

今天，你开发时遇到什么问题呢？

立即提问

热门标签