擅长:python、mysql、java
<h3>推荐</h3>
<pre><code>df.set_index(['pfl', 'date', 'cur'])
ID W
pfl date cur
adc 20030103 USD KLP 0.41
USD TRF 0.59
20030104 USD UTC 0.35
USD ZSE 0.65
</code></pre>
<hr/>
<h3>您的要求</h3>
<pre><code>a = ['pfl', 'date', 'cur']
b = ['ID', 'W']
pd.DataFrame(sum(
[[*zip(a, k)] + [b] + [*zip(*map(d.get, b))]
for k, d in df.groupby(a)], []
))
0 1
0 pfl adc
1 date 20030103
2 cur USD
3 ID W
4 KLP 0.41
5 TRF 0.59
6 pfl adc
7 date 20030104
8 cur USD
9 ID W
10 UTC 0.35
11 ZSE 0.65
</code></pre>