python - Pandas Groupby 占总数的百分比

Question

    df["% Sales"] = df["Jan"]/df["Q1"]
    q1_sales =  df.groupby(["City"])["Jan","Feb","Mar", "Q1"].sum()
    ql_sales.head()



                   Jan  Feb  Mar   Q1
City            
Los Angeles        44   40   54   138

希望代码获取该季度的销售额百分比。希望它看起来像下面每个月除以该季度的总销售额。

                     Jan    Feb   Mar  
City            
Los Angeles          31.9%  29%  39.1% 

Answer 1

尝试div:

q1_sales[['Jan','Feb','Mar']].div(q1_sales['Q1']*0.01, axis='rows')

输出:

                   Jan        Feb        Mar
City                                        
Los Angeles  31.884058  28.985507  39.130435