works locally, what to do
Code where the issue seems to be:
#function for viewing population data when clicked certain button on screen.
def choose():
#Select what will be shown
total = "Population Growth Finland"
female = "Females in Finland"
male = "Males in Finland"
selection = st.sidebar.radio("Select what chart will be shown.", [total, female, male])
data = "data\datapop1.xlsx"
data = pd.read_excel(data, usecols="A:N")
#TOTAL POPULATION
if selection == (total):
'''**Population growth in Finland 2000-2020**'''
### --- LOAD DATAFRAME
#Visualize population growth
plost.area_chart(data, "Year", "Population", height=250, color='#0a81c0')
plost.pie_chart(data, "Year", "Population", height=250)
data.set_index('Year', inplace=True)
#_____________________________________________________________________________________________________
#FEMALES OF TOTAL POPULATION!
elif selection == (female):
with col2:
st.metric("Females of Total Population", "50.69%", "-0.01%, since 2019",)
"Female population growth"
plost.area_chart(data, "Year", "Female", height=250, color='#673ba6')
data.set_index('Year', inplace=True)
#_________________________________________________________________________________________________________________
#MALES OF TOTAL POPULATION!
elif selection == (male):
with col2:
st.metric("Males of Total Population", "49.32%", "0.02%, since 2019",)
"Male population growth"
plost.area_chart(data, "Year", "Male", height=250, color='#8f2f03')
data.set_index('Year', inplace=True)
else:
'''Error! Please visit the app again soon!'''
choose()