Update app.py

worksheet.format(f"A1:A{len(global_df.index)}", { "numberFormat": { "type": TEXT, }, })

Update app.py

Update app.py

some cleanup

global_df.loc[len(global_df.index)] = row_data (keep eye out for int vs string)

working version exists; Issue is keeping consistent formatting between dataframe / google sheets

Update app.py

Update app.py

test

Update app.py

Update app.py

Update app.py

tests

Update app.py

re

Update app.py

Update app.py

Update app.py

printing to make sure sci notation isn't issue

Update app.py

Update app.py

test

str(member_id) to be compatible with sheets

Update app.py

print(type(global_df))

test

Update app.py

removing dataframe1 (old)

moving data = pd.read_csv("https://docs.google.com/spreadsheets/d/1hQSsIg1Y9WdBF_CdNM1L1rUUREoxKqRTe3_ILo-WK8w/export?format=csv&gid=0") outside

reorganize gradio demo / thread running discord bot (RuntimeError: cannot schedule new futures after shutdown)

switch

test2

test

retry (set_with_dataframe(worksheet, global_df) )

Update app.py

df['A'] = df['A'].astype(str)

Update app.py

Update app.py

Update app.py

Update app.py

df = get_as_dataframe(worksheet, dtype={‘a’: np.int64}

Update app.py

Update app.py

set_with_dataframe

Update app.py

Update app.py

Update app.py

revert for now; some bug with writing to google sheets (maybe try individual rows)

Update app.py