I use simple code snippet in streamlit which shows dataframe consisting of excel which i have. the problem is that it takes too much time to load data inside the filter column of streamlit area. in that filter area i make search on material name, but it takes even 30 seconds to load and show me the data which i am gonna select. How to solve it and make it fastest to select data?
The code is:
import streamlit as st import pandas as pd @st.cache def load_data(nrows): df=pd.read_excel('materials.xlsx',nrows=nrows) return df df=load_data(100000) species = st.multiselect('SELECT THE MATERIAL', df['Name']) new_df = df[(df['Name'].isin(species))] st.write(new_df)
and to show how it is too slow selecting data, look at this: https://streamable.com/kjis2