擅长:python、mysql、java
<p>让我们在{<cd3>}上尝试{a1}+{a2},然后{a3}返回{<cd5>}:</p>
<pre><code>df2['Column_df2'] = df2['Column_df2'].str.split(';')
df2 = df2.explode('Column_df2')
df3 = df1.merge(df2.rename(columns={'Column_df2': 'Column_df1'}),
on='Column_df1',
how='left')
</code></pre>
<p><code>df3</code>:</p>
<pre><code> Column_df1 Column_df2_value
0 abc aaa
1 pqr ppp
2 xyz jjj
</code></pre>