擅长:python、mysql、java
<p>您可以用<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.join.html" rel="nofollow noreferrer">^{<cd2>}</a>尝试<a href="https://www.google.com/search?q=series+str+extract&rlz=1C1GCEU_enIN822IN823&oq=series+str+extract&aqs=chrome..69i57j0l3j69i60.4025j0j4&sourceid=chrome&ie=UTF-8" rel="nofollow noreferrer">^{<cd1>}</a>:</p>
<pre><code>d=df1.set_index('Account').agg(list,axis=1).to_dict()
p='({})'.format('|'.join(df1.Account))
#'(B36363|G47281|H46291)'
m=pd.DataFrame(df2.Account.str.extract(p,expand=False).map(d).fillna('').tolist()
,columns=['ID','Name'],index=df2.index)
df2.join(m)
</code></pre>
<hr/>
<pre><code> Account Col_B Col_C ID Name
1 B36363-0 text_b1 text_c1 2019001 John
2 01_G47281 text_b2 text_c2 2019002;2018101 Alice;Emma
3 X_H46291 text_b3 text_c3 2019001 John
4 II_G47281 text_b4 text_C4 2019002;2018101 Alice;Emma
</code></pre>