Can't override values in a csv stored locally?

[Charly_Wargnier]

Hi guys,

I’m trying to override data in a csv file that is stored locally (that is, in the root folder).

the script below works fine in a Colab but not in Streamlit.

Here’s a screenshot of my csv file where I’m looking to override the number n (default value is 1) by n+1 with each run.

Here’s the code I’ve tried:

import streamlit as st
import csv
r = csv.reader(open("test.csv"))  # Here your csv file
lines = list(r)
lines
writer = csv.writer(open("test.csv", "w"))
lines[1][1] = int(lines[1][1]) + 1
writer.writerows(lines)

Each time I launch the script, all the data in the csv is erased.

Not sure (yet! :)) what I’m doing wrong

Thanks
Charly

[randyzwitch]

Hey @Charly_Wargnier -

Does this do what you want?

Incrementing Counter for button clicks

Hi @Bishop_Sankhe, welcome to the Streamlit community! This took a little more thinking than I expected! But you should be able to do this using the following: import streamlit as st with open("file.txt", "r") as f: a = f.readline() # starts as a string a = 0 if a == "" else int(a) # check if its an empty string, otherwise should be able to cast using int() if st.button("Click me"): a += 1 with open("file.txt", "w") as f: f.truncate() f.write(f"{a}") a

Best,
Randy

[Charly_Wargnier]

Thanks Randy!
I’ll check shortly and will feedback here.
Charly