python 列转成值 宽表转化为长表的方法

import pandas as pd
import numpy as np
 
 
# 样例
data = {'name':['严小样儿','严小样儿','严小样儿','才华横竖都溢','才华横竖都溢','才华横竖都溢','幽兰幽香','幽兰幽香','幽兰幽香'],
       'subject':['Python','C','SQL','Python','C','SQL','Python','C','SQL'],
       'score':[95,60,95,96,95,80,99,94,88]}
 
 
# 生成df
df = pd.DataFrame(data)

df.index=df.name
df.index.name=''
del df['name']

new_dt=pd.DataFrame(columns=['var_name','var_num'])
for ii in df.columns:
    i_np=np.transpose(df[ii])
    i_df=pd.DataFrame(i_np)
    i_df.columns=['var_num']
    i_df['var_name']=ii
    new_dt=new_dt.append(i_df)
    
print(new_dt)