我在Streamlit (1.3.1)中做了一个非常简单的应用程序:
预览
我使用来自st.selectbox
的回调来显示预览,这样只有在用户主动选择了他们感兴趣的工作表之后,它才会显示。但是为了做到这一点,我需要在调用st.selectbox
之前定义我的回调函数--这将导致预览显示在应用程序中的文件上传器和选择框小部件之上,而不是在我想要的地方,在这些小部件下面。
这是我的代码和我的输出的屏幕抓取。
import streamlit as st
import pandas as pd
# CREATE APP
# Add file_uploader
uploaded_file = st.file_uploader(
label='Upload a file', type=['xls', 'xlsx', 'xlsm'],
key='file-uploader',
help='''
Upload an Excel file. The file must be
closed in order for you to upload it.
'''
)
# Define function that loads sheet preview
def load_sheet_preview():
st.dataframe(df[st.session_state.selectbox_sheet])
# Add selectbox
if uploaded_file is not None:
df = pd.read_excel(uploaded_file, sheet_name=None) # sheet_name=None needs explicitly including - it isn't the default # noqa: E501
st.selectbox(
key='selectbox_sheet',
label='Select worksheet',
options=df.keys(),
on_change=load_sheet_preview
)
用函数包装生成文件上传器和选择框的代码,按照我希望它们出现在应用程序中的顺序,也不会对问题进行排序。
发布于 2022-02-03 20:43:58
我想出了一个解决方案,它涉及(显式地)使用st.session_state
而不是回调,并为下拉选项添加一个默认值。在选择默认选项时,未加载预览。
#!/usr/bin/env python
# -*- coding: utf-8 -*-
import io
import pandas as pd
import streamlit as st
# CREATE APP
# Add file_uploader
uploaded_file = st.file_uploader(
label='Upload a file', type=['xls', 'xlsx', 'xlsm'],
key='file-uploader',
help='''
Upload an Excel file. The file must be
closed in order for you to upload it.
'''
)
# Add selectbox
if 'selectbox_sheet' not in st.session_state: # Initialise variable
st.session_state['selectbox_sheet'] = '--'
if uploaded_file is not None:
sheets_dict = pd.read_excel(uploaded_file, sheet_name=None) # This creates a dictionary of dataframes. sheet_name=None needs explicitly including - it isn't the default # noqa: E501
default_option = {'--': ''}
selectbox_options = dict(**default_option, **sheets_dict) # Join dictionaries # noqa: E501
st.selectbox(
key='selectbox_sheet',
label='Select worksheet',
options=selectbox_options.keys()
)
# Load sheet preview
if st.session_state.selectbox_sheet != '--':
st.dataframe(sheets_dict[st.session_state.selectbox_sheet])
https://stackoverflow.com/questions/70824164
复制相似问题