<p>考虑下面的<code>pd.DataFrame</code></p>
<pre><code>temp = pd.DataFrame({'label_0':[1,1,1,2,2,2],'label_1':['a','b','c',np.nan,'c','b'], 'values':[0,2,4,np.nan,8,5]})
print(temp)
label_0 label_1 values
0 1 a 0.0
1 1 b 2.0
2 1 c 4.0
3 2 NaN NaN
4 2 c 8.0
5 2 b 5.0
</code></pre>
<p>我想要的输出是</p>
<pre><code> label_1 1 2
0 a 0.0 NaN
1 b 2.0 5.0
2 c 4.0 8.0
3 NaN NaN NaN
</code></pre>
<p>我试过<code>pd.pivot</code>和<code>pd.gropuby</code>争吵,但由于重复条目,无法获得所需的输出。非常感谢您的帮助</p>
<p>你可以做<code>fillna</code>然后<code>pivot</code></p>
<pre><code>temp.fillna('NaN').pivot(*temp.columns).T
Out[251]:
label_0 1 2
label_1
NaN NaN NaN
a 0 NaN
b 2 5
c 4 8
</code></pre>