Issue with caching data uploaded via the file uploader

Using Streamlit
#1

Hi Guys! (sorry me again, I’m on a roll with questions today! :stuck_out_tongue:)

I’m trying to upload tabular data from the file uploader.

Despite using the cache decorator @st.cache the way Andfanilo described it here, each I move anything (sliders, multi select etc…, see video below), data seems to be constantly re-uploading, which makes the app completely unsuable with any csv with a size greater than 3MB.

2020-06-25_17-03-39
2020-06-25_17-03-39710×404 2.03 MB

Here’s the Python code I’m using:

@st.cache(allow_output_mutation=True)
def load_data(file):
    df = pd.read_csv(file, encoding='utf-8', nrows=50)
    return df
uploaded_file = st.file_uploader("Choose a CSV file", type="csv", key='file_uploader')

I’m not sure if that’s expected - I’m pretty sure I’m doing something sub optimal here! :slight_smile:

Thanks in advance!

Charly

#2

Hi @Charly_Wargnier,
I am experiencing the same issue. Did you manage to resolve this issue at your end?
Thanks in advance!

1 Like
#3

Hey @mzeidhassan!

Try this:

st.markdown('### **1️⃣ Upload CSV file 👇 **')

@st.cache(allow_output_mutation=True)
def load_data(file):
    df = pd.read_csv(file, encoding='utf-8', nrows=50)
    df.columns = ['url', 'redir']
    return df

uploaded_file = st.file_uploader("", type="csv", key='file_uploader')

if uploaded_file is not None:
    df = load_data(uploaded_file)

Let me know if that works for you! :slight_smile:

Charly

1 Like
#4

Thanks @Charly_Wargnier for your prompt reply. I will give it a try. Thanks a million!

1 Like