<p>您可以<code>stack</code>第一个数据帧,然后将其转换为浮点类型,<code>map</code>第二个数据帧中的列,然后<code>unstack</code>最后<code>add_prefix</code>:</p>
<pre class="lang-py prettyprint-override"><code>df1.stack().astype(float).map(df2['district_name']).unstack().add_prefix('district_name')
</code></pre>
<p><strong>输出:</strong></p>
<pre class="lang-py prettyprint-override"><code> district_name0 district_name1 ... district_name3 district_name4
store_name ...
Store1 District1 District2 ... District4 District5
Store2 District1 District2 ... NaN NaN
Store3 District3 NaN ... NaN NaN
Store4 District4 District7 ... NaN NaN
Store5 NaN NaN ... NaN NaN
</code></pre>
<p>用于上述代码的数据帧:</p>
<pre class="lang-py prettyprint-override"><code>>>> df1
0 1 2 3 4
store_name
Store1 1 2 3 4 5
Store2 1 2 NaN NaN NaN
Store3 3 NaN NaN NaN NaN
Store4 4 7 10 15 NaN
Store5 12 15 NaN NaN NaN
>>> df2
district_name
district_id
1 District1
2 District2
3 District3
4 District4
5 District5
6 District6
7 District7
8 District8
9 District9
10 District10
</code></pre>