按国家分列的每组疫苗接种的熊猫数量

Question

BestV = vacc2.groupby(["location","vaccine"], as_index=False)[["total_vaccinations"]].count().sort_values(by='total_vaccinations',ascending=False)
BestV.head()

我需要按地点对每个疫苗制造商的注射总量进行分组，例如：

Argentina : Astra   12300
            Moderna 12551
            Pfizer  55200 
            ......
Brazil    : Astra   65412
            Moderna 14526
            Pfizer  14551  

我的数据集如下：

​

​

Answer 1

BestV = vacc2[['location', 'vaccine', 'total_vaccinations']] \
        .groupby(["location","vaccine"]) \
        .sum() \
        .sort_values(by='total_vaccinations', ascending=False) \
        .reset_index()

BestV.head()