[Excel]如何将表1转为表2

表1  

表2

import pandas as pd
from itertools import chain

data = pd.read_excel('c:/users/用户名/desktop/文件名.xlsx')
data_re = pd.melt(data,id_vars='姓名')
data2 = data_re.dropna(subset=['value'])

lis = []
for name, group in data2.groupby('姓名'):
    arri = group[['variable','value']].values
    lisi = list(chain.from_iterable(arri))
    lis.append([name]+lisi)

result = pd.DataFrame(lis,columns=['姓名','中心1','比例1','中心2','比例2','中心3','比例3'])