Saving data from users into a CSV file

[polgr98]

Hi, I want a web app which saves data from the user input and adds it into a CSV. The structure would be like this:

import csv
 
foo = "An"
bar = None
baz = "Example"

fields = [foo, bar, baz]
 
with open('Database.csv','a', newline='') as f:
    writer = csv.writer(f)
    writer.writerow(fields)

How can I deploy this?

[dataprofessor]

Hi @polgr98,

Yes, you can easily spin up a Streamlit web app to do that.

I would recommend to take a look at the Streamlit API Docs which does a great job of showing what you can do with the various Streamlit functions with example codes.

From what you described, you want to accept user input and write those to a CSV file.

Building the Streamlit app

Here’s what you can do to build the Streamlit app using 2 Streamlit functions (st.text_input and st.download_button):

• Use input widgets namely the st.text_input function to accept user text input. (Read more about st.text_input)
• Write user input to CSV file (what you already have)
• Encode the generated CSV file as a downloadable file via the st.download_button function (Read more about st.download_button)

Deploying the Streamlit app

You can easily deploy a Streamlit app using Streamlit Cloud which has a free and team tier.

More info on how to deploy a Streamlit app direct from the Streamlit Docs

Further learning

You can find some Streamlit tutorials on YouTube that you could follow, here are some:

• Playlist of 35 videos on Streamlit from Data Professor
• Playlist of 69 videos on Streamlit from JCharisTech
• Playlist of 9 videos on Streamlit from Avra
• Playlist of 9 videos on Streamlit from Misra Turp

Hope this helps!