Pandas和Matplotlib需要使用下拉列表按国家和特定国家首选疫苗的条形图接种百分比

Question

这是数据集

    location    date    vaccine total_vaccinations
0   Austria 2021-01-08  Johnson&Johnson 0
1   Austria 2021-01-08  Moderna 0
2   Austria 2021-01-08  Oxford/AstraZeneca  0
3   Austria 2021-01-08  Pfizer/BioNTech 30938
4   Austria 2021-01-15  Johnson&Johnson 0
... ... ... ... ...
8633    Uruguay 2021-07-05  Pfizer/BioNTech 1024793
8634    Uruguay 2021-07-05  Sinovac 3045997
8635    Uruguay 2021-07-06  Oxford/AstraZeneca  43245
8636    Uruguay 2021-07-06  Pfizer/BioNTech 1038942
8637    Uruguay 2021-07-06  Sinovac 3079853
8638 rows × 4 columns

我在Jupyter笔记本电脑公司工作

1. 需要接种疫苗的国家百分比
2. 使用下拉菜单（交互式绘图小部件）在特定国家绘制带有首选疫苗的条形图

Answer 1

我可以按国家提供百分比帮助，但不能提供条形图部分。您可以使用groupby、merge和math来获取所需的数字：

df = pd.DataFrame({'location': ['Austria', 'Austria', 'Austria', 'Austria'],
                   'vaccine': ['Moderna', 'Johnson&Johnson', 'Moderna', 'Johnson&Johnson'],
                   'total_vaccinations': [1, 2, 3, 4]})

# df_tcv = df_total_by_country_by_vaccine
df_tcv = df.groupby(['location', 'vaccine'], as_index=False)['total_vaccinations'].sum()

df_total_by_country = df_tcv.groupby('location', as_index=False)['total_vaccinations'].sum()
df_total_by_country = df_total_by_country.rename(columns={'total_vaccinations': 'location_total'})

df_tcv = df_tcv.merge(df_total_by_country, on='location', how='left')

df_tcv['pct_vac_by_c'] = df_tcv['total_vaccinations'] / df_tcv['location_total']

要获取df_tcv，请执行以下操作：

  location          vaccine  total_vaccinations  location_total  pct_vac_by_c
0  Austria  Johnson&Johnson                   6              10           0.6
1  Austria          Moderna                   4              10           0.4