python-3.x - 将项目数输出为标题 Pandas

Question

这是我的数据框:'''

 customer product     product1
0        A    hats        shoes
1        A   socks        shoes
2        B   socks        shoes
3        C    hats        shoes
4        C    None  accessories
5        B   socks        shoes
6        A    hats        shoes
7        C    None  accessories

'''我想输出这样的东西:

customer    shoes   hats    socks   accessories
A             #       #        #    #
B             #       #        #    #
C             #       #        #    #

我试过这样分组:'''

dfB.set_index('customer').groupby(['product', 'product1']).agg({'product':['count'], 'product1':['count']}) '''

我得到这样的输出:

'''

 product product1
                   count    count
product product1                 
 hats   shoes          3        3
 socks  shoes          3        3

'''

请帮忙

Answer 1

国际联合会

我们可以将索引设置为 'customer' 然后堆叠数据框，允许您使用 value_counts 进行聚合

df2 = df.set_index('customer').stack().groupby(level=0).value_counts().unstack()

-

print(df2)
          None  accessories  hats  shoes  socks
customer                                       
A          NaN          NaN   2.0    3.0    1.0
B          NaN          NaN   NaN    2.0    2.0
C          2.0          2.0   1.0    1.0    NaN

如果你不关心None，你可以将它转换成一个真正的空值，它会在groupby中被忽略

print(df.replace('None',np.nan).set_index('customer').stack().groupby(level=0).value_counts().unstack())

          accessories  hats  shoes  socks
customer                                 
A                 NaN   2.0    3.0    1.0
B                 NaN   NaN    2.0    2.0
C                 2.0   1.0    1.0    NaN