擅长:python、mysql、java
<p>使用<code>dropna= False</code></p>
<pre><code>df.stack(dropna=False).swaplevel(0,1).sort_index(level=0)
Out[261]:
0 address 123 Fake Street
email example@example.com
item Apple
notes None
orderTime 14:55
paymentStatus COMPLETED
refundNotes None
transactionID 2132123
1 address 123 Example Street
email fake@example.com
item Banana
notes None
orderTime 15:10
paymentStatus REFUNDED
refundNotes None
transactionID 54654645
2 address 123 Top Secret
email notreal@notreal.com
item Orange
notes None
orderTime 23:11
paymentStatus COMPLETED
refundNotes None
transactionID 56754646
dtype: object
</code></pre>