擅长:python、mysql、java
<p>查看这个<a href="https://stackoverflow.com/a/38432346/2336654">answer</a>了解在列上分解的各种方法</p>
<pre><code>rows = []
for i, row in df1.iterrows():
for a in row.abb:
rows.append([row['ID'], a, row['name']])
df11 = pd.DataFrame(rows, columns=df1.columns)
df11.merge(df2)
</code></pre>
<p><a href="https://i.stack.imgur.com/oGuAA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oGuAA.png" alt="enter image description here"/></a></p>