Code on submit of selectbox or radio selection inside form fails to show up

techb0lt · July 6, 2022, 6:34pm

Hi,

I have been scratching my head for two hours now and have read and re-read forms, selectbox and radio but am getting no where so thought I will ask here.

What I am trying to do is this:

Select Excel 1
Select Excel 2
if Excel 1 exists:
1. Obtain Sheets in Excel 1
2. Show Sheets in dropdown
if Excel 2 exists:
1. Obtain Sheet in Excel 2
2. Show Sheets in dropdown
User must select a Sheet from each of the above dropdowns
Using Sheetname, read data from that sheet into a dataframe.
Provide dropdown to show column names from each dataset
User must select the columns to compare
Comparison should then show for the specified column Venn Diagram and data with exclusive entries in each dataset.

Now, I have done a simpler version of this where I hard code the sheetname and last 4 steps will work. Problem I am facing is from Steps 3 to 5. So I read the sheets in uploaded excels and the sheets start displaying on the dropdown or as radio button. However, If I don’t have the selectboxes / radio inside a form, then the whole page refreshes and the dataframe gets loaded with the first sheet as that is what is selected by default. An additional entry “Select” added to ‘sheetnames’ did not help as everything just refreshed anyway.

I then added a form. With form added the screen was not refreshing by itself but after clicking on submit button it just refreshes the page and does not load the dataframes.

Not sure what I am doing wrong and any guidance will be hugely appreciated. The code is as shown below:

import streamlit as st
import pandas as pd
import numpy as np
from pandas import ExcelWriter
import re

def read_upload(obj_file,str_sheetname,col_list=None, date_col_list=False, file_type='xlsx'):
    import pandas as pd
    dataframe=""
    
    try:
        if obj_file is not None:
            if file_type == 'csv':
                dataframe = pd.read_csv(obj_file, usecols=col_list, parse_dates = date_col_list).applymap(lambda s: s.upper() if type(s) == str else s).fillna('')
            else:
                dataframe = pd.read_excel(obj_file,sheet_name = str_sheetname, usecols=col_list, parse_dates = date_col_list).applymap(lambda s: s.upper() if type(s) == str else s).fillna('')
            with st.expander(str_sheetname+" Sample", expanded=False):
                #st.markdown('**Sample of upload**')
                st.write(dataframe.head())
        else:
            dataframe="Empty - Upload a file first"
            st.warning(dataframe)			
    except ValueError as e:
        st.error("Problem: "+ e.args[0])
    finally:
        return dataframe

def get_sheetnames(upload_file):
    from openpyxl import load_workbook
    wb = load_workbook(upload_file, read_only=True, keep_links=False)
    return wb.sheetnames

file_upload_container = st.container()
sheet_selection_container = st.container()
column_selection_container = st.container()

with file_upload_container:
    f_col1, f_col2 = st.columns(2)
    f_button = st.empty()
with sheet_selection_container:
    s_col1, s_col2 = st.columns(2)
    s_button = st.empty()
with column_selection_container:
    c_col1, c_col2 = st.columns(2)
    c_button = st.empty()

with f_col1:
    f1_uploader = st.file_uploader(
        "Choose file 1",
        help="Upload the first file in .xls or .xlsx format",
        type=['xlsx','xls'])
    error_placeholder_f1 = st.empty()
with f_col2:
    f2_uploader = st.file_uploader(
        "Choose file 2",
        help="Upload the second file in .xls or .xlsx format",
        type=['xlsx','xls'])
    error_placeholder_f2 = st.empty()

with f_button:
    submitted = st.button("Upload")
if submitted:
    if f1_uploader is not None and f2_uploader is not None:
        # Read sheet names for both files
        f1_sheets = get_sheetnames(f1_uploader)
#        f1_sheets_mod = ("Select",*f1_sheets)
        f2_sheets = get_sheetnames(f2_uploader)
#        f2_sheets_mod = ("Select",*f2_sheets)
        with st.form(key="Select Column",clear_on_submit=False):
            sheet1 = st.radio("File 1 Sheets",f1_sheets, help = "Select a sheet from this list")
            st.write("You selected: ", sheet1)
            sheet2 = st.radio("File 2 Sheets",f2_sheets, help = "Select a sheet from this list")
            st.write("You selected: ", sheet2)
            submit_button = st.form_submit_button(label='Submit')

            if submit_button:
                #if sheet1 != "Select" and sheet2 != "Select":
                with f_col1:
                    st.write(sheet1)
                    sheet1_data = read_upload(f1_uploader,sheet1)
                with f_col2:
                    st.write(sheet2)
                    sheet2_data = read_upload(f2_uploader,sheet2)
                #else:
                #    st.warning('Sheets for comparison must be selected.')


    elif f1_uploader is None:
        with error_placeholder_f1:
            st.error("Please upload file 1.")
    else:
        with error_placeholder_f2:
            st.error("Please upload file 2.")

techb0lt · July 8, 2022, 11:52am

Well I have just figured out that it was the button after file uploads which was causing the complete refresh each time. If I remove that button it does work as expected. However, I am none the wiser on how to achieve the button functionality as I intended. Guidance will be appreciated. Code that works as expected is as shown below:

import streamlit as st
import pandas as pd
import numpy as np
from pandas import ExcelWriter
import re

def read_upload(obj_file,str_sheetname,col_list=None, date_col_list=False, file_type='xlsx'):
    import pandas as pd
    dataframe=""
    
    try:
        if obj_file is not None:
            if file_type == 'csv':
                dataframe = pd.read_csv(obj_file, usecols=col_list, parse_dates = date_col_list).applymap(lambda s: s.upper() if type(s) == str else s).fillna('')
            else:
                dataframe = pd.read_excel(obj_file,sheet_name = str_sheetname, usecols=col_list, parse_dates = date_col_list).applymap(lambda s: s.upper() if type(s) == str else s).fillna('')
            with st.expander(str_sheetname+" Sample", expanded=False):
                #st.markdown('**Sample of upload**')
                st.write(dataframe.head())
        else:
            dataframe="Empty - Upload a file first"
            st.warning(dataframe)			
    except ValueError as e:
        st.error("Problem: "+ e.args[0])
    finally:
        return dataframe

def get_sheetnames(upload_file):
    from openpyxl import load_workbook
    wb = load_workbook(upload_file, read_only=True, keep_links=False)
    return wb.sheetnames

file_upload_container = st.container()
sheet_selection_container = st.container()
column_selection_container = st.container()

with file_upload_container:
    f_col1, f_col2 = st.columns(2)
    f_button = st.empty()
with sheet_selection_container:
    s_col1, s_col2 = st.columns(2)
    s_button = st.empty()
with column_selection_container:
    c_col1, c_col2 = st.columns(2)
    c_button = st.empty()

with f_col1:
    f1_uploader = st.file_uploader(
        "Choose file 1",
        help="Upload the first file in .xls or .xlsx format",
        type=['xlsx','xls'])
    error_placeholder_f1 = st.empty()
with f_col2:
    f2_uploader = st.file_uploader(
        "Choose file 2",
        help="Upload the second file in .xls or .xlsx format",
        type=['xlsx','xls'])
    error_placeholder_f2 = st.empty()

#with f_button:
#    submitted = st.button("Upload")
#    if submitted:

if f1_uploader is not None and f2_uploader is not None:
    # Read sheet names for both files
    f1_sheets = get_sheetnames(f1_uploader)
    f1_sheets_mod = ("Select",*f1_sheets)
    f2_sheets = get_sheetnames(f2_uploader)
    f2_sheets_mod = ("Select",*f2_sheets)

    with sheet_selection_container:            
        with s_col1:
            sheet1 = st.selectbox("File 1 Sheets",f1_sheets_mod, help = "Select a sheet from this list")
        with s_col2:
            sheet2 = st.selectbox("File 2 Sheets",f2_sheets_mod, help = "Select a sheet from this list")
        
        if sheet1 == "Select" or sheet2 == "Select":
            st.warning('Sheets from both files must be selected for comparison.')
            st.stop()
        else:
            with s_col1:
                st.write(sheet1)
                sheet1_data = read_upload(f1_uploader,sheet1)
            with s_col2:
                st.write(sheet2)
                sheet2_data = read_upload(f2_uploader,sheet2)
elif f1_uploader is None:
    with error_placeholder_f1:
        st.error("Please upload file 1.")
else:
    with error_placeholder_f2:
        st.error("Please upload file 2.")

system · July 8, 2023, 11:53am

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Streamlit to select excel sheet name and pass the selection to dataframe reader 🎈 Using Streamlit	3	2383	August 10, 2023
How can I create a dynamic form that refreshes data? 🎈 Using Streamlit	1	317	February 7, 2024
Selectbox and Slider 🎈 Using Streamlit selectbox , slider	2	2225	January 12, 2022
Newb to Streamlit, easy Selectbox question I am sure 🎈 Using Streamlit selectbox , pandas	7	2844	February 17, 2023
Why does changing the value of streamlit selectbox cause the entire page to refresh each time? 🎈 Using Streamlit session-state , selectbox , pandas , debugging	4	141	March 25, 2024

Code on submit of selectbox or radio selection inside form fails to show up

Related Topics

Hello there 👋🏻

Cookie settings

Strictly necessary cookies

Performance cookies

Functional cookies

Targeting cookies