如何使用FOR/LIST/DICTIONARY理解(不是SQL)使用Python左外部联接? [英] How to use Python left outer join using FOR/LIST/DICTIONARY comprehensions (not SQL)?

问题描述

我有两个元组，详细信息如下:

I have two tuples, details below:

t1 = [
['aa'],
['ff'],
['er']
]

t2 = [
['aa', 11,],
['er', 99,]
]

并且我想使用类似于SQL的LEFT OUTER JOIN的python方法获得以下类似结果:

and I would like to get results like these below using python method similar to SQL's LEFT OUTER JOIN:

res = [
['aa', 11,],
['ff',  0,],
['er', 99,]
]

请帮助我.

推荐答案

d2 = dict(t2)
res = [[k[0], d2.get(k[0], 0)] for k in t1]

这篇关于如何使用FOR/LIST/DICTIONARY理解(不是SQL)使用Python左外部联接?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！