To be honest, I’m new to Pandas and to Streamlit, however, I tried to do some stuff for my personal interest.

Here’s the script so far:

import pandas as pd
import streamlit as st

st.title('Vaccine Overview')

@st.cache_data
def get_data():
    df = pd.read_csv('https://opendata.sozialversicherung.at/eimpfpass/COVID19_vaccination_agegroups_v202210.csv', sep=';')
    return df

df = get_data()

df_age_vacc = df.query('state_id == 11')\
    [['age_group','vaccine','vaccinations_administered_cumulative']]\
        .groupby(['age_group','vaccine'])['vaccinations_administered_cumulative']\
            .sum()

df_age_vacc.index.set_names(['Altersgruppe','Impfstoff'], inplace=True)
df_age_vacc.rename('Menge', inplace=True)

st.bar_chart(df_age_vacc)

Whenever I run the script using Streamlit I get the following error:
KeyError: "The following 'id_vars' are not present in the DataFrame: ['index']"

What am I doing wrong here? As I noted I’m an absolute beginner with this, Pandas is not my domain.

Any help is very appreciated. Thanks.

In [70]: df_age_vacc.index
Out[70]: 
MultiIndex([(      '00-11',    'AstraZeneca'),
            (      '00-11', 'BioNTechPfizer'),
            (      '00-11',        'Janssen'),
            (      '00-11',        'Moderna'),
            (      '00-11',        'Novavax'),
            (      '00-11', 'Sanofi Pasteur'),
            (      '00-11',        'Valneva'),
            (      '12-14',    'AstraZeneca'),
            (      '12-14', 'BioNTechPfizer'),
            (      '12-14',        'Janssen'),
            (      '12-14',        'Moderna'),
            (      '12-14',        'Novavax'),
            (      '12-14', 'Sanofi Pasteur'),
            (      '12-14',        'Valneva'),
            (      '15-24',    'AstraZeneca'),
            (      '15-24', 'BioNTechPfizer'),
            (      '15-24',        'Janssen'),
            (      '15-24',        'Moderna'),
            (      '15-24',        'Novavax'),
            (      '15-24', 'Sanofi Pasteur'),
            (      '15-24',        'Valneva'),
            (      '25-34',    'AstraZeneca'),
            (      '25-34', 'BioNTechPfizer'),
            (      '25-34',        'Janssen'),
            (      '25-34',        'Moderna'),
            (      '25-34',        'Novavax'),
            (      '25-34', 'Sanofi Pasteur'),
            (      '25-34',        'Valneva'),
            (      '35-44',    'AstraZeneca'),
            (      '35-44', 'BioNTechPfizer'),
            (      '35-44',        'Janssen'),
            (      '35-44',        'Moderna'),
            (      '35-44',        'Novavax'),
            (      '35-44', 'Sanofi Pasteur'),
            (      '35-44',        'Valneva'),
            (      '45-54',    'AstraZeneca'),
            (      '45-54', 'BioNTechPfizer'),
            (      '45-54',        'Janssen'),
            (      '45-54',        'Moderna'),
            (      '45-54',        'Novavax'),
            (      '45-54', 'Sanofi Pasteur'),
            (      '45-54',        'Valneva'),
            (      '55-64',    'AstraZeneca'),
            (      '55-64', 'BioNTechPfizer'),
            (      '55-64',        'Janssen'),
            (      '55-64',        'Moderna'),
            (      '55-64',        'Novavax'),
            (      '55-64', 'Sanofi Pasteur'),
            (      '55-64',        'Valneva'),
            (      '65-74',    'AstraZeneca'),
            (      '65-74', 'BioNTechPfizer'),
            (      '65-74',        'Janssen'),
            (      '65-74',        'Moderna'),
            (      '65-74',        'Novavax'),
            (      '65-74', 'Sanofi Pasteur'),
            (      '65-74',        'Valneva'),
            (      '75-84',    'AstraZeneca'),
            (      '75-84', 'BioNTechPfizer'),
            (      '75-84',        'Janssen'),
            (      '75-84',        'Moderna'),
            (      '75-84',        'Novavax'),
            (      '75-84', 'Sanofi Pasteur'),
            (      '75-84',        'Valneva'),
            (        '85+',    'AstraZeneca'),
            (        '85+', 'BioNTechPfizer'),
            (        '85+',        'Janssen'),
            (        '85+',        'Moderna'),
            (        '85+',        'Novavax'),
            (        '85+', 'Sanofi Pasteur'),
            (        '85+',        'Valneva'),
            ('NotAssigned',    'AstraZeneca'),
            ('NotAssigned', 'BioNTechPfizer'),
            ('NotAssigned',        'Janssen'),
            ('NotAssigned',        'Moderna'),
            ('NotAssigned',        'Novavax'),
            ('NotAssigned', 'Sanofi Pasteur'),
            ('NotAssigned',        'Valneva')],
           names=['Altersgruppe', 'Impfstoff'])

In [71]: type(df_age_vacc)
Out[71]: pandas.core.series.Series

>Solution :

You might need to unstack your data as bar_chart is using the index as x and the columns as y and internally melts the data:

st.bar_chart(df_age_vacc.unstack())

Output: