如何在Panda Python中分裂

Question

我生成了以下代码：

cov_vac_merge['Partially Vaccinated'] = cov_vac_merge['First Dose'] - cov_vac_merge['Second Dose']

cov_vac_merge['% Partially Vaccinated'] = cov_vac_merge['Second Dose'] / cov_vac_merge['First Dose']

covid_summary= cov_vac_merge.groupby('State')[['Vaccinated','First Dose','Second Dose','Partially Vaccinated','% Partially Vaccinated']].sum().sort_values('Partially Vaccinated' ,ascending=False)

在代码的第二行中，我尝试将第二剂量除以第一次剂量，我没有得到正确的结果。在我获得的输出示例的下方：

State Vaccinated  First Dose     Second Dose     Partially Vaccinated   % Partially Vaccinated
  UK     5606041     5870786      5606041                264745                 527.854055     

不再获得527.85的部分接种疫苗，我应该得到5606041/5870786 = 0.95 。有人知道我在代码的部门部分中做错了什么？

Answer 1

我认为代码应该是这样的：

covid_summary = cov_vac_merge.groupby('State').agg({
    'Vaccinated': np.sum,
    'First Dose': np.sum,
    'Second Dose': np.sum,
    'Partially Vaccinated': np.sum,
    '% Partially Vaccinated' : np.mean,  
})

有关熊猫中的分组和聚合的详细信息，我建议阅读这篇官方文章。