使用将2行合并为1行

Question

下面是一个数据帧的小例子。每个用户都有2行，我想把这2行合并成1行

（原始数据帧）

USER       DETAIL          TEAM         VALUE
JohnDoe    Disponibily     Architect    107
JohnDoe    Capacity        Architect    240
JamesDean  Disponibily     Coder        80
JamesDean  Capacity        Coder        110

我正试图通过熊猫来实现这样的目标：

USER       TEAM            Disponibily  Capacity
JohnDoe    Architect       107          240
JamesDean  Coder           80           110

任何帮助都将不胜感激

Answer 1

使用pivot_table

df = pd.DataFrame(data={"USER":["JohnDoe","JohnDoe","JamesDean","JamesDean"],
                       "DETAIL":["Disponibily","Capacity","Disponibily","Capacity"],
                       "TEAM":["Architect","Architect","Coder","Coder"],
                       "VALUE":[107,240,80,110]})
res = pd.pivot_table(df,index=['USER','TEAM'],columns='DETAIL',values='VALUE').reset_index()
res.columns.name = ''

        USER    TEAM    Capacity    Disponibily
0    JamesDean  Coder       110       80
1    JohnDoe    Architect   240       107