pandas groupby列，然后根据第三列创建另外两个列 [英] pandas groupby column then create two other columns based on third column

问题描述

我试图按列对数据框进行分组，并基于此分组获取总的已批准"或未批准"值，但未成功.

I am trying to group a dataframe by a column and get the total "Approved" or "Not Approved" values based on this grouping, but with no success.

示例:

PlaceTest | Approved    
       21 |        1    
       21 |        0    
       22 |        1    
       22 |        0

我想要的输出:

PlaceTest | Approved | NotApproved    
       21 |        1 |           1    
       22 |        1 |           1

谢谢！

推荐答案

给出

>>> df
   PlaceTest  Approved
0         21         1
1         21         0
2         22         1
3         22         0

您可以发布

>>> df.assign(NotApproved=1 - df['Approved']).groupby('PlaceTest').sum().reset_index()
   PlaceTest  Approved  NotApproved
0         21         1            1
1         22         1            1

这篇关于 pandas groupby列，然后根据第三列创建另外两个列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！