👉Website Demo: share.streamlit.io/sven-bo/streamlit-income-expense-tracker/app.py 👉Streamlit Playlist: ru-vid.com/group/PL7QI8ORyVSCaejt2LICRQtOTwmPiwKO2n 👉Deploy your streamlit app for free on Heroku: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-nJHrSvYxzjE.html 👉Add user authentication to your app: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-JoFGrSRj4X4.html 💬I will be here in the comments section. For any issues, please provide your exact error message, and I will try to help.
Год назад
Hey, just wanted to drop a quick note to say thank you for making that RU-vid video! It was seriously so helpful and I loved how you presented the material. Great job!
Excellent tutorial. I like your code organisation with all these sections and comments, will borrow this from you. BTW never heard of Sankey charts. Thank you for sharing this with us. ❤️
This is brilliant! I finally start to understand some core Python/programming-concepts and this is a great tool for learning more. I especially liked the database-bit, which I didn`t believe I would. Well done! I recommend your channel whenever I can.
Excellent video as always! Fast, clean and nice explanation of every aspect! I learned Streamlit from you, thx for finding the time to make these excellent videos. I have a request. Could you show us how to edit an entry in the database? Not from the db panel, but from inside the streamlit app.
Great to hear! Regarding your request, you could use the 'update' method (docs.deta.sh/docs/base/sdk#update) In this video, you can see an example on how to use it: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-eCbH2nPL9sU.html I hope it helps! :)
This is fantastic! I just started to learn Python and found your great video!!! May I ask two questions. I received "No module named 'database' " error message from Python, but the code still runs (with data stored in deta), which is really strange. Also, what if I have a multipage streamlit app and need to collect multiple user inputs on different pages? I think it can be very complicated. Do you have any advice or reference to recommend?
Thanks for watching. Hard to tell from a distance why you are getting an error message. Not sure about your exact use-case, but you can also collect (save data to a database) on multiple pages. Happy Coding!
@@CodingIsFun Thank you! :) One follow-up question. Should we type "pip install database" before we "import database from db" ? or since we created database.py, we do not need to install anything?
Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!
Thanks for watching and for your suggestion. I'll keep it in mind. In the meantime, you might find the following tutorial on connecting Streamlit to S3 useful: docs.streamlit.io/knowledge-base/tutorials/databases/aws-s3. Happy coding!
If anyone else is annoyed by the warnings about missing labels, you can change the `st.expander("Comments") part to: ``` with st.expander("Comments"): comment = st.text_area("comment", placeholder="Enter comment...", label_visibility="hidden") ```
Very good tutorial. Really help me in learning streamlit. By the way, hope you can make some small tutorials on Deta. Another question is, can you share some code to show how to sum all expenses in a year, instead of in a month. TQ
Thank you. Glad you liked the video. Here is your code to sum up all incomes for all periods: entries = fetch_all_periods() total_income_all_entries = sum([sum(entry['incomes'].values()) for entry in entries]) Happy Coding!
awesome tutorial, congratulations. but i'm with problems to implement. the main page works, but when i click in data visualization the error "HTTPError: HTTP Error 401: Unauthorized" appears. Please help me, i'm not a expert, i just trying to implement the projetc until the end.
Thanks a lot Sir... Your explanations are too good. I did learn a lot from you . One question Sir. Is it possible to update the data which I have already added. I like to do the update in the application itself . Otherwise one can fetch the data and do the correction with out going to the DB. I appreciate it.. thanks...Manohar
hey @coding is fun. i am having trouble getting my api key from deta as when i go to thier website its asking me to request for devoloper accses and then create a project in "builder" is there anyway to get your api key instally like you did in the video? thanks.
Thanks for watching. The interface from Deta has changed quite a lot. I myself now find it much harder to navigate there. I would suggest having a look at their updated documentation.
As always great video! Thanks for sharing your wisdom with us. I can't manage to make the config.toml file to not break my streamlit app. Whenever I save the file, a new error appears and it is about streamlit not being able to read utf-8 or something. Nothing on the internet has helped me so far. Have you ever faced this kind of problems with themes?
Ensure your config.toml is UTF-8 encoded and without special characters. Verify the file syntax and its location in a .streamlit directory at your project root. Also, make sure you're using Streamlit v0.79 or newer, which support themes. If these don't help, sharing your error message can help to pinpoint the issue better.
AttributeError: module 'streamlit' has no attribute '_is_running_with_streamlit'.This error happens every time I try to plot the Hiplot view. Do you have any tips to resolve?
Thanks for watching. Unfortunately, with that bit of information, I cannot help you. You might want to take some time to write down which line of code is causing the error; let me know if you have modified the code from the tutorial, explain in more depth what you did to troubleshoot the problem and provide some more context. Thanks!
Hey everyone, I am getting this error: Missing Submit Button This form has no submit button, which means that user interactions will never be sent to your Streamlit app. To create a submit button, use the st.form_submit_button() function. And I have the correct code ... submitted = st.form_submit_button("Sava Data") if submitted:
Thanks for watching. Are you referring to the new streamlit feature? blog.streamlit.io/introducing-multipage-apps/ What exactly is the issue you are facing?
Hey there , Why in the world did you choose that Deta platform to create the database bro, a new user like me even can't find how to get the api key to create a database Worst experience 😞 bro, everything was going fine untill you started with the deta platform.......
Good tutorial, but too much time is wasted on Deta NoSQL database. Database popularity statistics don't lie. Most Python developers want simple, local SQLite databases to start, then PostgreSQL, MySQL, and other SQL databases. Please redo this tutorial using SQLite. Thank you.
Thank you for your videos. Please could you help me with the following question. After I import a .csv with only two decimals like 1.00 or 333.00, the following lines don't maintain those two decimal. Those decimals become 1.000000 or 333.000000. I would like to have only two decimal. Could you help!? with st.expander("Table"): st.write(category_df.style.background_gradient(cmap="Blues")) csv = category_df.to_csv(index=False).encode('utf-8') st.download_button("Download", data=csv, file_name="file.csv", mime="text/csv", help='Click here to download') with st.expander("Table"): df_selection["month"] = df_selection["date"].dt.month_name() sub_category_Year = pd.pivot_table(data=df_selection, values="amount", index=["name"], columns="month") st.write(sub_category_Year.style.background_gradient(cmap="Blues")) with st.expander("filtered"): st.write(df_selection.iloc[:500, 0:20:1].style.background_gradient(cmap="Blues_r"))
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
Great video, it would be interesting to see if any of the st caching magic decorators apply to connecting to the db? Or is that reopened each time the app reloads?
You Sir are awesome. These tutorials are easy to follow and you do a great job explaining what its happening, thank you. One question if I may, could you do a tutorial for using a local db rather than a cloud based one? I ask as I like many have real restrictions on where we can send and store our data. And for my application it would need to be a local db using postresql for example? Or would it be easy to modify what you have here maybe?
Thanks for watching. Yes, deta cloud changed to deta space. I am also not very happy with that change 😅 Please refer to the deta space documentation: deta.space/docs/en/reference/base/sdk I hope it helps! Happy Coding!
Hello, and THANK YOU. Streamlit is now one of my favourite tools thanks to your helpful videos and tutorials. Just one thing though if you could please help, Deta is now upgraded to Space I think and I can't set it up.
Thanks for watching. I'm happy to hear that you found my Streamlit tutorials helpful. That's right - Deta Cloud is now Deta Space. So, the steps I've shown here are not exactly the same. You'll need to check out the updated Deta Space documentation: deta.space/docs/en/introduction/start/. Good luck with your project, and happy coding!
Great video! Could you do another video where you add a budget creation step with a table that has drop-downs for selecting the expense/income accounts? This would be hugely helpful and applicable for a job I am working on.
If I can take the time to say how much I enjoyed this content and such a rich solution to a Streamlit App development . I am self taught now for 7 years and I really seem to identify with your style of coding. Ex. Using different list in settings and looping through to establish your datasets. I just love the way this came together and it was well thought out and delivered. My only concern is what of Deta is Depricated for some reason ? I guess doing a fetchall and storing on a local DB would do the trick using cron job ? Your thoughts are appreciated...
Thank you for watching and for your kind words. I'm glad to hear that you appreciate my coding/teaching style. Regarding your question: Yes, Deta has undergone significant changes in recent months. The product is now called Deta Space (which you can still use for this project, but the steps differ, and you would need to refer to the current documentation). However, as you mentioned, you could also use any other database of your choice. Happy coding! :)
Sir ,your videos are flawless. I have a query that is : streamlit customized themes are not applied even though I have saved .streamlit/config.toml files in all my projects else everything works fine. Please help me out of this problem
Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!
Thank you for an excellent video. I look forward to watching more of your videos! (deta is very different and the website is a bit of a nightmare to navigate (imho) so I chose a different path there.)
Have you done anything on inventory management ? I am in the shipping/logistics space and what to build something for my team of 3 - shipping containers to be more specific
Hi Max Musterman ;) Ich nutze die Jupyter Notebook Erweiterung 'Zen Mode': towardsdatascience.com/three-jupyter-notebook-extensions-that-minimize-distractions-bd9ec98f0e2c Beste Grüße zurück Sven
I have never used Jupyter Notebook's for testing streamlit application, but there might be some possibilities. Check out the following discussion: discuss.streamlit.io/t/working-with-jupyter-notebooks/368 In the video, I have used the text editor 'Atom'. I hope it helps!
@@CodingIsFun thanks for replying, you are becoming my favourite programmer.. I mean floats for the expenses and incomes. But tried %f and it showed an error and that it would still be an integer.
You may be using multiple Python environments, and the updated pip is installed in a different one. Make sure you're using the correct environment or try using "python -m pip" instead of just pip.
@@CodingIsFun I just wanted to say a huge thank you for teaching me programming! As a teacher, I was a complete noob until you showed me the ropes a few weeks back. Now, I've got four awesome Streamlit apps that make my job a lot more fun. Let me buy you a coffee to say thanks! And by the way, what's your favorite IDE for coding?
@@arnoldtvisagie Awesome work on making those four Streamlit apps! It's great to hear that I was able to help you along the way. My favourite IDE is definitely VS Code - it's got so many cool features and extensions. Thank you for offering to support me with a coffee ☕! You can do so here: pythonandvba.com/coffee-donation. Keep up the good work. Happy Coding! 🚀
@@CodingIsFun sqlalchemy not db thise is like python ORM make translation to SQL. You can write query code on python, and automate translate to many SQL dialects. Like django ORM.
@@CodingIsFun sqlalchemy not db thise is like python ORM make translation to SQL. You can write query code on python, and automate translate to many SQL dialects. Like django ORM.
@@CodingIsFun Oh. Damn, I thought it was introduced at the beginning. Anyways, A very good video. I got to learn many tricks! My favorite: col1.metrics. :D :)