擅长:python、mysql、java
<p>也可以不使用<code>pd.melt</code>来获得解决方案:</p>
<pre><code>data = {
"SomeCol":[1,2],
"Group1":['x','y'],
"Group2":['a','b'],
"SomeAgg":[100,200]
}
df = pd.DataFrame(data)
col_names = ['Group1', 'Group2']
df['Var1'], df['Var2'] = col_names[0], col_names[1]
df = df.rename(columns={col_names[0]: 'Var1_Value', col_names[1]: 'Var2_Value'})
print(df)
SomeCol Var1_Value Var2_Value SomeAgg Var1 Var2
0 1 x a 100 Group1 Group2
1 2 y b 200 Group1 Group2
</code></pre>