擅长:python、mysql、java
<p>创建一个字典(<code>mapping</code>),将键映射到它们的值,从<code>df2</code>(列<code>0</code>是键,列<code>1</code>是它们对应的值</p>
<p>然后使用嵌套列表理解来查找值并使用<code>assign</code>将其附加到<code>df1</code></p>
<pre><code>df1 = pd.DataFrame({'values': [['acd3f','rt5gh8','5ty7e'], ['rt5gh8','t67ui']]})
df2 = pd.DataFrame({0: ['acd3f', 'rt5gh8', '5ty7e', 't67ui'],
1: ["I am cool", "I am not cool", "ok_sir", "no_sir"]})
mapping = {k: v for k, v in zip(df2[0], df2[1])}
>>> df1.assign(value_names=[[mapping.get(val) for val in sublist]
for sublist in df1['values'] ])
values value_names
0 [acd3f, rt5gh8, 5ty7e] [I am cool, I am not cool, ok_sir]
1 [rt5gh8, t67ui] [I am not cool, no_sir]
</code></pre>