擅长:python、mysql、java
<p>使用可怕的循环</p>
<pre><code>df3 = pd.DataFrame(index=df1.index, columns=np.unique(df1.values))
for (d, c), v in df2.stack().iteritems():
df3.set_value(d, df1.get_value(d, c), v)
df3
</code></pre>
<p><a href="https://i.stack.imgur.com/XCaLn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XCaLn.png" alt="enter image description here"/></a></p>