Hello,
how to read data on a graph after retrieving data from the database (SQLite3)
currently I get a list of data like this
and I would like to put them on a graph
Thank you for reading, and Happy Streamlit-ing!
Hello,
how to read data on a graph after retrieving data from the database (SQLite3)
currently I get a list of data like this
and I would like to put them on a graph
Thank you for reading, and Happy Streamlit-ing!
Hi @Simon_Elsen ,
Thanks for posting and welcome to the Streamlit community!
can you explain to me what is not working? I would expect st.bar_chart(…) to work. You could also use st.plotly_chart or st.altair_chart.
It looks like perhaps you need to add a line return rows
to your select_all_tasks, since right now it’s just printing the rows, not actually returning them.
indeed I had forgotten that, thank you
However I still don’t have the solution, it seems to come from the packages but I have my requirements.txt which is in the github repo in the same root as the main page so I don’t understand the problem
here are the errors in the streamlit console
my dateRecorded and prod are elements read from the sqlite db, then I implement them in the bar_char() via the x= and y= can I do this? it doesn’t seem to be recognized
Hi @Simon_Elsen, the next step I would recommend is using st.write(graph3_data)
to see what columns are actually in that dataframe.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
These cookies are necessary for the website to function and cannot be switched off. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms.
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us understand how visitors move around the site and which pages are most frequently visited.
These cookies are used to record your choices and settings, maintain your preferences over time and recognize you when you return to our website. These cookies help us to personalize our content for you and remember your preferences.
These cookies may be deployed to our site by our advertising partners to build a profile of your interest and provide you with content that is relevant to you, including showing you relevant ads on other websites.