I have the script below I typed in Pycharm for my Streamlit Data app: import pandas as pd import plotly.express as px import streamlit as st st.set_page_config(page_title='Matching Application Number', layout='wide') df = pd.read_csv('Analysis_1.csv') st.sidebar.header("Filter Data:") MeetingFileType = st.sidebar.multiselect( "Select File Type:", options=df['MEETING_FILE_TYPE'].unique(), default=df['MEETING_FILE_TYPE'].unique() ) df_selection = df.query( 'MEETING_FILE_TYPE == @MeetingFileType' ) st.dataframe(df_selection) The output of this on streamlit is: Application_ID MEETING_FILE_TYPE BBC#:1010 1 NBA#:1111 2 BRC#:1212 1 SAC#:1412 4 QRD#:1912 2 BBA#:1092 4 How can I return matching Application_ID results just for 1&2 like below: Filter Data: Application_ID MEETING_FILE_TYPE select type: BBC#:1010 1 1 2 NBA#:1111 2 BRC#:1212 1 QRD#:1912 2 Then, how can I download the data results above from Streamlit into a csv file?, Thank you.
To upload files, please first save the app
import pandas as pd
import numpy as np
import streamlit as st
st.set_page_config(page_title='Matching Application Number', layout='wide')
if "df" not in st.session_state:
# Generate some mocked data
num_rows = 100
meeting_file_types = [1, 2, 3, 4]
data = {
'MEETING_FILE_TYPE': np.random.choice(meeting_file_types, num_rows),
'Value': np.random.rand(num_rows) * 100
}
st.session_state.df = pd.DataFrame(data)
st.sidebar.header("Filter Data:")
MeetingFileType = st.sidebar.multiselect(
"Select File Type:",
options=st.session_state.df['MEETING_FILE_TYPE'].unique(),
default=[1,2]
)
# Filter DataFrame based on selection
if MeetingFileType:
df_selection = st.session_state.df.query('MEETING_FILE_TYPE in @MeetingFileType')
else:
df_selection = st.session_state.df
st.write("Filtered Data:")
st.dataframe(df_selection)
# Download functionality
def convert_df_to_csv(df):
return df.to_csv(index=False).encode('utf-8')
csv = convert_df_to_csv(df_selection)
st.download_button(
label="Download data as CSV",
data=csv,
file_name='filtered_data.csv',
mime='text/csv'
)Hi! I can help you with any questions about Streamlit and Python. What would you like to know?