<p><strong>选项1</strong><br/>
<code>unstack</code>+<code>reset_index</code>-</p>
<pre><code>df.unstack().reset_index(level=0, drop=True)
</code></pre>
<p/>
<pre><code>paymentStatus COMPLETED
address 123 Fake Street
item Apple
transactionID 2132123
orderTime 14:55
email example@example.com
refundNotes None
notes None
paymentStatus REFUNDED
address 123 Example Street
item Banana
transactionID 54654645
orderTime 15:10
email fake@example.com
refundNotes None
notes None
paymentStatus COMPLETED
address 123 Top Secret
item Orange
transactionID 56754646
orderTime 23:11
email notreal@notreal.com
refundNotes None
notes None
</code></pre>
<hr/>
<p><strong>选项2</strong><br/>
<code>stack</code>+<code>sort_index</code>+<code>reset_index</code></p>
<pre><code>df.stack().sort_index(level=1).reset_index(level=1, drop=True)
</code></pre>
<p/>
<pre><code>paymentStatus COMPLETED
address 123 Fake Street
item Apple
transactionID 2132123
orderTime 14:55
email example@example.com
paymentStatus REFUNDED
address 123 Example Street
item Banana
transactionID 54654645
orderTime 15:10
email fake@example.com
paymentStatus COMPLETED
address 123 Top Secret
item Orange
transactionID 56754646
orderTime 23:11
email notreal@notreal.com
</code></pre>
<p>注意<code>stack</code>会删除NaN值,因此可能不是您的最佳选择</p>