擅长:python、mysql、java
<p>创建列表,参见str.split、explode和左合并</p>
<pre><code>df2=df2.assign(Column_df2=df2['Column_df2'].str.split(';')).explode('Column_df2')
pd.merge(df1,df2, how='left', left_on='Column_df1', right_on='Column_df2')
Column_df1 Column_df2_value Column_df2
0 abc aaa abc
1 pqr ppp pqr
2 xyz jjj xyz
</code></pre>